Special Character - Remove Nonbreaking Space

[k_v_deepu]

Hi

i have downloaded some data to excel. it has got leading Nonbreaking Spaces as shown below

<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0 x:str><COLGROUP><COL style="WIDTH: 192pt; mso-width-source: userset; mso-width-alt: 9362" width=256><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl25 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 192pt; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" width=256 height=17>CLEANSERS</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 192pt; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" width=256 height=17> LOTIONS/MILKS/CREAMS</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 192pt; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" width=256 height=17> OTHER</TD></TR></TBODY></TABLE>

Can anyone help me in removing this
i tried find and replace method in excel to remove space
and also tried trim function but it didn't work

thanks

 

[Ulli8]

You can also use the Find and Replace box. Click in the Find box, hold Alt key and type 0160 on the number keypad then release Alt; leave the Replace box blank, and hit Replace All.

Thank you so much, you kept me sane today. the number keypad is key!!