How to add "PS" in front of text in Excel 2010?
I have 3 formats of General Text in Excel 2010. They all look like either 3001, 3001R, or F3001. How can I add a "PS" in front of each line of text to read PS3001, PS3001R, or PSF3001 without adding PS manually for 800+ values?
- JASONLv 63 weeks agoFavorite Answer
Put ="PS"&A1, where A1 is the cell reference for the first entry you want to put it in front of. Then copy the formula down. If you want to overwrite the original numbers, highlight the new column which has the PS now at the start, copy, then paste values over the original data.
- ∅Lv 73 weeks ago
highlight the cells you want to change, click Replace, and replace * with PS*
- Spock (rhp)Lv 73 weeks ago
search and replace. look up [help screens] how to do this
- ChrisLv 73 weeks ago
Use Search and Replace (Ctrl+H), then simply enter "3001" and "PS3001" and click "Replace all".
Repeat for the other two.