View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
filky
 
Posts: n/a
Default How do I merge new text into existing text cells.


enter .jpg into cell B61 for example and assume that you have filenames
10001 and 10002 running down the column starting in A61, A62 etc.
Then type in to cell C61

=+A61&$B$61

The just drag the cell down to copy against each one.


--
filky
------------------------------------------------------------------------
filky's Profile: http://www.excelforum.com/member.php...o&userid=11801
View this thread: http://www.excelforum.com/showthread...hreadid=492599