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

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?
--
capxc

Adding alpha-numeric value in from all alphabetic content in acol
 

="08FG55"&D1

then copy down

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

Do I put this command in format cell?
How to copy down?
Sorry , I am not very techie.
Please give me some lights.
Sincerely,
--
capxc


"Jarek Kujawa" wrote:

="08FG55"&D1

then copy down

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

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.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"capxc" wrote:

Do I put this command in format cell?
How to copy down?
Sorry , I am not very techie.
Please give me some lights.
Sincerely,
--
capxc


"Jarek Kujawa" wrote:

="08FG55"&D1

then copy down