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

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.

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

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.

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

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....
Editpastespecialvaluesok
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


"muppetlover27" wrote:

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.