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

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

capxc

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

M Kan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add the same alpha-numeric value to all the content of a co 3
Alpha with numeric and numeric only numbers in a column 6
separating alpha numeric vlue 23
Move selected Text/Numbers from Col D to Col A/B 17
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Lookup the last alpha numeric value in a column 4
adding zero th alpha numeric value 1
Maintaining text data format in a pivot table 0

Top