ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i get a cell in a sheet to show the last 1024 characters? (https://www.excelbanter.com/excel-worksheet-functions/108678-how-do-i-get-cell-sheet-show-last-1024-characters.html)

XenneX

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?

Dave Peterson

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


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com