Could be any number of reasons, some of which are addressed in your previous
posting.
TRIM, CLEAN can get rid of some extras.
Non-breaking spaces due to HTML will not respond to Trim or Clean.
Do an EditReplace for Alt + 0160
Enter the 0160 on the numpad.
Could be linefeeds like 0010 or 0013
Chip Pearson has a neat little add-in utility called CellView which shows
you what is in your cells.
http://www.cpearson.com/excel/CellView.aspx
Before you go there.........try this macro
Sub Remove_CR_LF()
With Selection
..Replace what:=Chr(160), replacement:="", _
lookat:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
..Replace what:=Chr(13) & Chr(10), replacement:="", _
lookat:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
..Replace what:=Chr(10), replacement:="", _
lookat:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
End With
End Sub
Gord Dibben MS Excel MVP
On Fri, 12 Feb 2010 11:24:37 -0800 (PST), "J.W. Aldridge"
wrote:
worksheet created from downloaded data. when clicking on cells with
data, format cell option not available. macros wont recognize data as
data either. some data is words and some numbers. any way to convert
entire page format to the appropiate text & numbers?