Creating individual cells for a cell with long text

[deante]

Hello all,

I have copied a table from the internet into excel. However, excel treats each row of the table I copied and puts it in one cell for each row. I need certain information on the table from the internet to do some data analysis. I used the MID function to put the long text into their own appropriate cells. However, I am trying to see if one value falls between two of the values on the table I got from the internet. When I use a formula to determine this I get a #Num! error, I believe because it looks at the number as text, eventhough it actually is a number. I can not format the text as a number, and there are too many entries to edit the entries by hand.

Heres an example,

name date time in time out (this all would be in A1)

Want it to be

Name Date Time In Time Out

(all in different columns)



Thanks for your help in advanced

 

[xlhelp]

Experiment with Text-to-columns to separate the strings. If done right, your data will convert to numbers at the same time.

Member AAA - Abolish Abused Abbreviations