ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a character maximum per cell (https://www.excelbanter.com/excel-discussion-misc-queries/223331-there-character-maximum-per-cell.html)

soconfused

Is there a character maximum per cell
 
I was wondering if there is a maximum number of characters you can have in a
cell?
--
DMM

Ron Rosenfeld

Is there a character maximum per cell
 
On Fri, 6 Mar 2009 05:16:02 -0800, soconfused
wrote:

I was wondering if there is a maximum number of characters you can have in a
cell?


Yes there is, and it may be different in different versions.

Check HELP for Specifications and Limits.
--ron

Mike H

Is there a character maximum per cell
 
Hi,

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.


have a loo here for Excel specifications and limits

http://office.microsoft.com/en-us/ex...992911033.aspx

Mike



"soconfused" wrote:

I was wondering if there is a maximum number of characters you can have in a
cell?
--
DMM


DILipandey

Is there a character maximum per cell
 
Hi Soconfused,

Just checked.. in excel 2003 you can enter "32767" characters in a cell.
Thanks,
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"soconfused" wrote:

I was wondering if there is a maximum number of characters you can have in a
cell?
--
DMM


Dave Peterson

Is there a character maximum per cell
 
You can see more than the 1000 or so characters documented in xl's help by
adding alt-enters (to force new lines within the cell) every 80-100 characters.

Mike H wrote:

Hi,

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

have a loo here for Excel specifications and limits

http://office.microsoft.com/en-us/ex...992911033.aspx

Mike

"soconfused" wrote:

I was wondering if there is a maximum number of characters you can have in a
cell?
--
DMM


--

Dave Peterson


All times are GMT +1. The time now is 12:15 PM.

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