[Pepsione1]

10/21/2007 19:00:00,0.239

How can I parse the above information from a single cell. Move it into 3 separate cells then I can plot it in a chart. It reads, "date" "time" & "value".

 

[Orcin]

The data needs to be in a single cell for this to work. It looks like yours is. I tested it, and I believe this will do it.

1. If it is not already there, paste the data into your spreadsheet. Select the data.
2. Choose (from the dropdown menus) Data, then Text to Columns. This will open a wizard.
3. Step 1 - choose "Delimited"
4. Step 2 - Make sure space and comma are checked
5. Step 3 - You can format the columns here, then Finish.

You should now have three columns containing your data.

 

[rb67]

If your aren't using Excel 2007

data > text to columns>delimited and choose space, comma

i'm not familiar with 2007 to tell you what menus

 

[Febs]

Quote:

Originally Posted by Pepsione1 /img/forum/go_quote.gif 10/21/2007 19:00:00,0.239 How can I parse the above information from a single cell. Move it into 3 separate cells then I can plot it in a chart. It reads, "date" "time" & "value".

Assuming that your information is in cell A1 and your data will always have the same number of characters, you could do something like this:

Cell B1: =LEFT(A1,10)
Cell C1: =MID(A1,12,8)
Cell D1: =RIGHT(A1,5)

This will return text. If need the date to be in date format, you could then parse it further using the date functions. So cell B1 could be something like this:

=DATE(MID(A1,7,4),LEFT(A1,2),MID(A1,4,2))


Quote:

Originally Posted by rb67 /img/forum/go_quote.gif If your aren't using Excel 2007 data > text to columns>delimited and choose space, comma i'm not familiar with 2007 to tell you what menus

This works too.

 

[Pepsione1]

Ah. that was easy. Thanks folks.