formula to remove leading space - data from dbase.

[hawilder]

Hi-

I did copy/paste lots and lots of pages from an online database into excel and the data all has a hidden leading space that is not recognized when i do find and replace or =trim. Any suggestions? I am trying to compare this data against other data in excel and all the formulas are "false" unless i remove that space manually -- has to be a better way.
Help is appreciated.
Holly

 

[Osvaldo Palmeiro]

Keying in a Non-breaking space CHAR(160) <small>(#nbsp)</small>

To manually Replace a Char(160) value which is known as a non-breaking space ( ) in HTML or a required blank (RBL) in rich text formatted documents use one of the following:
on a desktop Ctrl+H then
Find what -- hold the Alt and key in 0160 with Alt+0160 on the numeric keypad (Not the number row)
Replace with -- leave the to field empty and use Replace All

on a laptop Ctrl+H then
Find what -- hold the Alt and key in 0160 with Fn+0160 on the numeric keypad
Replace with -- leave the to field empty and use Replace All

this is located at
Shortcut Keys in Excel 2000 through 2007
​

 

[hawilder]

Worked perfect - thanks so much!!!!!!!!!