Assuming your column A, type in B ="M"&A2 and copy down.
Regards
Cimjet
"muppetlover27" wrote in message
...
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.