Is there a maximum number of characters in a cell

G

gord9b

Board Regular
Joined
Jun 12, 2002
Messages
249
I back up my Microsoft Outlook noes in Excel but when I do, some of my longer notes get truncated. Is this because there is a maximum number of characters in a cell? If so, what is it and how can I get around it?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Yes, the limit is 32,767 (only 1024 will display in the cell).

How do you get around it? Not sure I can help with that.
As far as I know, there is no getting around that limit in Excel.

Perhaps you might be able to MS Word or Access
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Modify a worksheet without registering it as a change
Replies
1
Views
108
Kaper
Kaper
P
  • Question Question
Maximum number of pairings
Replies
1
Views
261
StephenCrump
S
Keebellah
  • Question Question
Excel VBA determine amount of characters
Replies
2
Views
336
Keebellah
Keebellah
H
  • Solved
Remove Brackets containing Numbers with a simple criteria
Replies
6
Views
478
Tom.Jones
T
N
  • Solved
COUNTA Function not counting any cells
Replies
1
Views
142
nithchun
N

Forum statistics

Threads
1,224,587
Messages
6,179,734
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top