Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do i get a cell in a sheet to show the last 1024 characters?

How do I get a cell in a sheet to display the last 1024 characters instead of
the first 1024 characters when the cell contains more than 1024 characters?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default how do i get a cell in a sheet to show the last 1024 characters?

Can you use another cell that shows those last 1024 characters.

=right(a1,1024)

By the way, you can see lots more than 1024 characters in the cell if you add
alt-enters (to force a new line within the cell) every 80-100 characters.

XenneX wrote:

How do I get a cell in a sheet to display the last 1024 characters instead of
the first 1024 characters when the cell contains more than 1024 characters?


--

Dave Peterson
Reply
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 copy the cell contains above 255 characters from one sheet. Senthil Excel Discussion (Misc queries) 1 August 8th 06 04:48 AM
Sum up columns in different sheet with error check zeyneddine Excel Discussion (Misc queries) 13 July 10th 06 01:21 PM
Display text 1024 characters in a cell Martin Excel Worksheet Functions 6 November 12th 05 11:25 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM


All times are GMT +1. The time now is 12:31 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"