| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add text to existing text in a whole column in Excel? | Excel Discussion (Misc queries) | |||
| How to add text to all existing records in one column? | Excel Discussion (Misc queries) | |||
| How to create a prefix containing text and zero? | Excel Worksheet Functions | |||
| adding extra text into an existing column | Excel Worksheet Functions | |||
| how do i prefix a column with letters | Excel Discussion (Misc queries) | |||
Threaded Mode
