How do I set an 'M' prefix to existing text in a column?

  • Thread starter Thread starter muppetlover27
  • Start date Start date
M

muppetlover27

Hi
I have a column of part numbers which are of varying length and start with
varying letters. I would like to add 'M' to the beginning of every cell so
for example
A2115401717 would become MA2115401717. I'm fairly new to excel so I'm not
sure if this is even possible. I would appreciate any help.
 
hi
if your new then lets keep it simple.
add a "helper" column next to your part number column.
if your example was in A2 then in the helper column(B2?) put this formula..
="M"&A2
Copy the fomula down as far as you need.
copy the helper column and on the menu bar....
Edit>pastespecial>values>ok
this will convert the formula to hard numbers and letters.
keep the helper column, delete the original part number column.(or archive
it. your data, your call)

regards
FSt1
 
Back
Top