View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
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