Ask Experts Questions for FREE Help !
Ask
    jmccormick's Avatar
    jmccormick Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 19, 2011, 11:11 AM
    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.
    jakester's Avatar
    jakester Posts: 582, Reputation: 165
    Senior Member
    		  
    #2

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

In Excel 2003 how do I add two spaces in a cell before the text [ 8 Answers ]

One or two spaces after a period? [ 9 Answers ]

I recently heard that for literary works one should use one space between sentences. Is gthis true?

How do you alphabetize exact names with spaces and without spaces [ 1 Answers ]

What would you put first. Van De Vanter or Vandevanter.

Remove blank spaces [ 3 Answers ]

How cam we remove the blank spaces in a String like " a s k " to make it "ask"

View more questions Search