Text to column

[Sara]

Hello,
I am trying to use the text to column tool for to put the following data
into its own cell.

~Scan/Tag: SN - 8/20/2008 - 2:01:59 PM*
~Sign: WB - 8/20/2008 - 1:00:17 PM
~Review: KG - 8/20/2008 - 12:01:48 PM
~Final: CF - 8/20/2008 - 9:51:44 AM
~Approve: WB - 8/19/2008 - 4:31:54 PM
~Review: WB - 8/19/2008 - 1:27:54 PM
~Admin Proof: RR - 8/19/2008 - 11:42:33 AM
~Rework: CF - 8/19/2008 - 10:59:29 AM
~Admin Proof: RR - 8/19/2008 - 10:42:43 AM
~Admin Draft: CF - 8/19/2008 - 9:20:34 AM
~PM Proof: WB - 8/19/2008 - 8:09:31 AM
~IA Prep: JE - 8/18/2008 - 11:46:16 AM
~Assign:

I was trying to use the delimited tool with the ~ symbol to distinguish
where the cell should begin, but when I do this it only will give me the
first row (Scan/tag). What can I do to make this work for me?
I greatly appreciate any assistance!

 

[JasonP CCTM LV]

There are a couple of things that I can think of that would return just the
one line.

Do you have blank rows between the rows of data?
Are you selecting the entire column before using the delimiter?

 

[Dave Peterson]

I'd do two things...

#1. Select the column and:
Edit|Replace
what: ctrl-j
with: (leave blank)
replace all

Hit and hold the ctrl key while you strike the j key. This will replace the
alt-enters (char(10)'s) with nothing, but that's ok.

#2. Now do the data|Text to columns.
delimited by ~

 

[Dave Peterson]

ps. That giant string is in a single cell, right?