LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KJM KJM is offline
external usenet poster
 
Posts: 6
Default Split non delimited data into multiple cells

How do I split a single cell of data into multiple cells, when it is a
continous text string without delimiter characters? I want each single
charcter of the string in its own cell.

I am importing an ascii file and can separate the data manually during
importi, using the fixed width, delimiter function, but it makes me manually
place the seperator bar between each character. I could have up to 511
character text string so this is a bit tedious, and there doesn't seem to be
hot keys to do this, so a Macro doesn't seem possible.
 
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
how can I split one cell's data into two cells? Excel Worksheet Functions 3 May 15th 06 01:19 AM
Adding up data in multiple cells for a single criteria. Philip Excel Worksheet Functions 1 April 5th 06 11:30 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
How do I retrieve data (specific cells) from multiple worksheets on a shared drive jbean Excel Worksheet Functions 1 November 10th 04 09:26 PM


All times are GMT +1. The time now is 06:21 PM.

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

About Us

"It's about Microsoft Excel"