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!
|