breaking single cell into individual cells so i can find

Hi

To split the data you can use the Data/text to columns feature and select space as the delimiter.

If you have a great deal of data to enter you could try the following. Browsers deal with copying and pasting a little differently and Explorer will usually give the result that you experienced. Often using Firefox the same data copied and pasted will arrive correctly in Excel, it may be worth trying.

Regards

Jeff

Y ou could try this:-
If you know how to, you can copy this bit of code into a Command Button.
Failing that Write an empty Macro and copy the code below into it, between
the words Sub Macro?? & End Sub.
The code refers to your (One cell) list of information in Range("B1) and the resulting output
of individual numbers, prefixed by "$" will be in column "A"
Amend these Ranges addresses to suit your needs

Please Login or Register  to view this content.

You will need to Format Column "A" as currency "$" to One decimal Place
Regards Mick G