Remove Space in between, front and last of cell

[chandsu]

Hi All,

How to remove a space in between, front & last in a excel, since i have a huge data

for example

i have in col something like this

S01 E201 = in another column i need like this S01E201
if there is space before the letter S and if there is space after the last letter 1 in need to remove the space in the excel

for more clarificaiton

Col A</SPAN>	Col B</SPAN>
S01 E201</SPAN>	S01E201</SPAN>
S02E201</SPAN>	S02E201</SPAN>
S03E111 </SPAN>	S03E111</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>

 

[jeneves]

Hi All,

How to remove a space in between, front & last in a excel, since i have a huge data

for example

i have in col something like this

S01 E201 = in another column i need like this S01E201
if there is space before the letter S and if there is space after the last letter 1 in need to remove the space in the excel

for more clarificaiton

Col A	Col B
S01 E201	S01E201
S02E201	S02E201
S03E111	S03E111

<tbody>
</tbody>

Hi, have you tried to use ctrl + h to replace space (hit space once) for nothing (dont fill anything in the Replace with)

 

[d'Holbach]

Try:

=Substitute(A1," ","")