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

X

XenneX

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

Limits of Substitute and Replace functions 4
Small Thick "Bar" Below Last Typed Line ? 0
How to ignore text on SUM() function... 16
Excel text export limit - 1024 per line (not cell), workaround? 11
Ignore text but not numerics on SUM() function 1
Find next cell with more than 1024 characters 3
Display text > 1024 characters in a cell 6
How to disable Alt+s in Outlook 365 0

Top