Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Chart - Adding text in the column in Excel 2007 Jennifer Charts and Charting in Excel 2 July 26th 08 02:58 PM
Return text in Column A if Column B and Column K match jeannie v Excel Worksheet Functions 4 December 13th 07 07:36 PM
To copy values in a column relevant to text in an adjacent column? Guy Keon Excel Worksheet Functions 2 November 15th 05 08:10 PM
Wrap text in column headers to fit text in column MarkN Excel Discussion (Misc queries) 10 November 11th 05 04:21 AM
How I can print full text bigger than column, in repeat column Prince Excel Discussion (Misc queries) 0 August 11th 05 07:28 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"