how do i get a cell in a sheet to show the last 1024 characters?

G

Guest

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display text > 1024 characters in a cell 6
How to ignore text on SUM() function... 16
Ignore text but not numerics on SUM() function 1
Counting characters in a cell 3
How do you print all data in a cell? 1
Excel text export limit - 1024 per line (not cell), workaround? 11
Find next cell with more than 1024 characters 3
Error message is Character Limit is over 1024 characters 2

Top