Adding alpha-numeric value in from all alphabetic content in a col

  • Thread starter Thread starter capxc
  • Start date Start date
C

capxc

I asked similar question for numbers a day ago and it was resolved
This time I need to add alpha numeric value (say 08FG55) in front of all the
contents of a partucular column(say D). And The current content of column D
are only alalphabetic content , no numbers.
How do I do it?
 
Do I put this command in format cell?
How to copy down?
Sorry , I am not very techie.
Please give me some lights.
Sincerely,
 
You'll have to write this formula Jarek gave you in a new column and then
copy the formula down the length of your data set.
 
Back
Top