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
Lookup the last alpha numeric value in a column 4
Alpha & Numeric Counts in Excel 3
Extract alpha from a cell 1
Using text values in Pivot Tables 5
How to delete fist 6 digit of all contents in a column? 8
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5

Top