Sleeper: Extend Cell Column Width

[sheeeng]

Hello,

I would like to know how to extend cell column width beyond 255 characters.

But from Microsoft website, http://office.microsoft.com/en-us/assistance/HP051992911033.aspx, it seem that it is impossible... :(

I use Excel to store scientific formula that are usually very long, more than 255 characters. :help

Please advise.

[Killian]

Hi there,

It appears to me that this is a limit set in Excel's specification and therefore cannot be exceeded. If the formulae are obscuring neighboring cells you'll have to switch wrap text on

[sheeeng]

Thanks, Killian.
To clarify what I meant,
Can a excel worksheets cell contain more than 255 characters?

[Justinlabenne]

If it's possible, store the data in seperate cells on another worksheet and Concatenate the cells. This is the only reliable way I can think of right off..
:think:

[sheeeng]

If it's possible, store the data in seperate cells on another worksheet and Concatenate the cells. This is the only reliable way I can think of right off..
:think:

Thanks, Justin.

Well, I would like to know is there is a possiblity to store more than 255 character in Excel Cell?

Thx.:friends:

[Justinlabenne]

This has more than 255 characters in cell A1

[johnske]

Hi,

Have a look at this kb entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=421) by byundt

John

[sheeeng]

This has more than 255 characters in cell A1

How you did it? :doh:

[sheeeng]

Hi,

Have a look at this kb entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=421) by byundt

John

Thx, John....
Come through last time...
Forgotten bout it...
Thx for reminding...:friends: