View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
muppetlover27 muppetlover27 is offline
external usenet poster
 
Posts: 1
Default 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.