Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy the cell contains above 255 characters from one sheet. | Excel Discussion (Misc queries) | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Display text 1024 characters in a cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |