View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
depuyus[_5_] depuyus[_5_] is offline
external usenet poster
 
Posts: 1
Default Concantenate and align info??

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