Text to column
 

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!

Text to column
 

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?

"Sara" wrote:

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!

Text to column
 

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 ~


Sara wrote:

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!

--

Dave Peterson

Text to column
 

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

Sara wrote:

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!

--

Dave Peterson