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