Text to column

  • Thread starter Thread starter Sara
  • Start date Start date
S

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!
 
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?
 
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 ~
 
Back
Top