space to be remove in excel [SOLVED]

[webmax]

Hi


I have the excel in the data contain space followed by the letter.


when i try to remove the space using proper formula it does not removes the space.


can you give any solution for removing the space.

 

[Colin Legg]

Hi,

PROPER() will change the first letter on each word to upper case and change all other letters to lower case.


TRIM()

will remove all spaces from a text string except for single spaces between words.

 

[ThrottleWorks]

Hi Webmax,


If you want to remove all the spaces from the data, please use substitute formula.


This formula will remove all the spaces, for example.


webmax webmax (3 spaces used) will be converted to webmaxwebmax.


But if you want the result as webmax webmax (only 1 space) then I honestly do not know the answer, experts on the forums will help you on that


P.S. - I had forgot about =trim function :-(

 

[webmax]

hi can you put the substitue formula

 

[ThrottleWorks]

Hi Webmax,


=SUBSTITUTE(A1," ","")


Please confirm whether you want to use =SUBSTITUTE and not the =TRIM.

=SUBSTITUTE will remove all the spaces.


Example, your value in cell A1 = webmax1 webmax2 webmax3 webmax4

This will be converted to webmax1webmax2webmax3webmax4.


P.S. - If you want to know details about =SUBSTITUTE, PFB the link.


http://chandoo.org/excel-formulas/substitute.shtml

 

[webmax]

thanks working fine