Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How can I remove spaces before and after + signs in a cell? (https://www.askmehelpdesk.com/showthread.php?t=571421)

  • Apr 19, 2011, 11:11 AM
    jmccormick
    How can I remove spaces before and after + signs in a cell?
    Example the string BaciTRACIN + Neomycin + Polymyxin B Topical should be BaciTRACIN+Neomycin+Polymyxin B Topical.
  • Apr 19, 2011, 12:30 PM
    jakester

    Jm - use the Find and Replace feature... easily found by hitting the ctrl + h together.

    Type in the "Find what:" section the text string as follows: (leading space) + (following space)

    Replace with: + (no spaces)

    Worked for me.

  • All times are GMT -7. The time now is 04:59 AM.