Log in

View Full Version : How can I remove spaces before and after + signs in a cell?


jmccormick
Apr 19, 2011, 11:11 AM
Example the string BaciTRACIN + Neomycin + Polymyxin B Topical should be BaciTRACIN+Neomycin+Polymyxin B Topical.

jakester
Apr 19, 2011, 12:30 PM
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.