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?

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?