LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Martin
 
Posts: n/a
Default Display text 1024 characters in a cell

Cell B2 contains a narrarrtive - say 5000 characters. The cell will only
display 1024 characters.

I would like to display the first 800 or so characters, ending with a
period, in cell B3.

The next 800 or so characters, ending with a period, in cell B4 and so on
into B5 etc.

This has me stumped. How would this be done and if so can row height be
adjusted by formula?

Thank you,

--
Martin
 
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
Wrap Text Mark Leyden Excel Discussion (Misc queries) 7 October 13th 05 06:29 PM
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
MS Excel 2000 Cell Capacity and Data Display RCM-IEWTD Excel Discussion (Misc queries) 3 August 11th 05 05:05 PM
Display ALL text contents in cell Flipper1067 Excel Discussion (Misc queries) 10 July 27th 05 02:22 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM


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

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"