| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Don't ever be sorry for offering help to someone... You done good ;-)
Bill -------------------- SheriTingle wrote: Sorry, I didn't see that Bill had already answered your question. : ) "Betty Turvy" wrote: How do you add the same prefix or suffix to a range of cells, without changing the existing numbers in that range. ie. if you have these numbers in a row of cells: 123 456 234 899 and you want them to read PR123 PR456 PR234 PR899 I want to add this PR prefix to all these numbers in a row of cells, without typing the prefix into each cell. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
| Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
| Adding to a range in a reference? | New Users to Excel | |||
Threaded Mode
