Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) |