Thread: formula help
View Single Post
  #3  
Old February 10th, 2010, 04:21 PM posted to microsoft.public.excel.worksheet.functions
eduardo
external usenet poster
  
Posts: 2,131
Default formula help
Hi,
In an adjacent column enter

=2&a1

"Soth" wrote:

Hi-

Issue:
211
310
410
569

Would like to accomplish:
2211
2310
2410
2569

How do I add number 2 infront of the above ISSUE numbers as I have thousands
of line to do.

Soth