View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Adding letter at the end of cell

Hi

With numbers in Column A, in another column enter
=A1&"A" or whatever letter you want to Add
Copy down
Copy this new column and Paste SpecialValues back over column A.

--
Regards

Roger Govier


"Wanna Learn" wrote in message
...
Hello I have a column and I need to add a letter at the end of each
number
in the column I tried find and replace and I'm obviously doing it
wrong.
What is the best way to do this ? again thanks