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?

4 Answers

    Lv 6
    3 weeks ago
    Favorite 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 7
    3 weeks ago

    highlight the cells you want to change, click Replace, and replace * with PS*

  • 3 weeks ago

    search and replace.  look up [help screens] how to do this

  • Chris
    Lv 7
    3 weeks ago

    Use Search and Replace (Ctrl+H), then simply enter "3001" and "PS3001" and click "Replace all".

    Repeat for the other two.

Still have questions? Get your answers by asking now.