S
soconfused
I was wondering if there is a maximum number of characters you can have in a
cell?
cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Rosenfeld
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
M
Mike H
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/excel/HP051992911033.aspx
Mike
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/excel/HP051992911033.aspx
Mike
D
DILipandey
Hi Soconfused,
Just checked.. in excel 2003 you can enter "32767" characters in a cell.
Thanks,
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
Just checked.. in excel 2003 you can enter "32767" characters in a cell.
Thanks,
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
D
Dave Peterson
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.
adding alt-enters (to force new lines within the cell) every 80-100 characters.