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

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

FSt1

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
 

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

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Insert prefix and suffix to existing string 1
How can the font and size of (all) citation numbers be altered? 1
Prefix 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Page numbering with Merged Document and IF statements 1

Top