I am trying to concantenate information from three columns into one s
that the info contained in the three columns can be viewed on a use
form. The form works great but because the cells hold information o
different lengths it displays the information all unaligned as below:
h1&" "h2&" "h3
$14 blah blah etcetc
$142 blah blah etcetc
$1433 blahblah etcetc
Is it possible to establish the string lenth for each h instead o
trying to make it space so that the information would align?
I thank you in advance for any suggestions
--
Message posted from
http://www.ExcelForum.com