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

[TABLE="width: 128"]
<TBODY>[TR]
[TD]Col A</SPAN>[/TD]
[TD]Col B</SPAN>[/TD]
[/TR]
[TR]
[TD]S01 E201</SPAN>[/TD]
[TD]S01E201</SPAN>[/TD]
[/TR]
[TR]
[TD] S02E201</SPAN>[/TD]
[TD]S02E201</SPAN>[/TD]
[/TR]
[TR]
[TD]S03E111 </SPAN>[/TD]
[TD]S03E111</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2></COLGROUP>[/TABLE]

 

[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

[TABLE="width: 128"]
<tbody>[TR]
[TD]Col A[/TD]
[TD]Col B[/TD]
[/TR]
[TR]
[TD]S01 E201[/TD]
[TD]S01E201[/TD]
[/TR]
[TR]
[TD] S02E201[/TD]
[TD]S02E201[/TD]
[/TR]
[TR]
[TD]S03E111 [/TD]
[TD]S03E111[/TD]
[/TR]
</tbody>[/TABLE]

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," ","")