LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BCBC
 
Posts: n/a
Default Split one cell into many

I am editing a database in Excel that will be dumped into another program.
Some of my cells in Excel have over 1000 characters of text (in
sentence/paragraph format). The other program has a limit of 250 characters
in each field. This means that I need to split the data of each cell into
multiple smaller cells.

I tried using DataText to Columns, but this inserts preset breaks which I
have to move one-by-one. Since my Excel document has almost 1000 rows and
several columns, I'm sure you can imagine how long that would take. Does
anyone know how this can be done quickly?
 
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 to split the unmerge cell in Excel? RR Excel Discussion (Misc queries) 3 July 29th 05 01:29 PM
How do I split one cell of 6 numbers into two cells of 3 and 3? Jason Excel Discussion (Misc queries) 2 July 26th 05 03:42 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
How to split the contents of a cell between two cells. Colin Hayes Excel Worksheet Functions 4 June 11th 05 01:21 AM
Can I split a cell diagonally, with text in each triangle ? Helen T Excel Discussion (Misc queries) 1 May 13th 05 04:32 PM


All times are GMT +1. The time now is 04:58 AM.

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"