How Many Characters In A Formula?

  • Thread starter Thread starter Minitman
  • Start date Start date
M

Minitman

Greetings,

Does anyone how many characters are allowed in a cell formula?

Also, is there anyway to find out how many characters are actually in
a cell formula?

TIA

-Minitman
 
Minitman said:
Greetings,

Does anyone how many characters are allowed in a cell formula?
Click to expand...

32,767 characters. Only 1,024 display in a cell; all 32,767 display in
the formula bar.
Also, is there anyway to find out how many characters are actually in
a cell formula?
Click to expand...

MsgBox Len(ActiveCell.Formula)
 
Sorry, I'm wrong.

The maximung length of a formula contents appears to be 1,024 characters
 
Hey Steve,

Don't be sorry, a simple correction is all that is required and
appreciated,

1024, that's good to know. My biggest cells have 554 characters and
growing, just a bit over half full. <G>

Thanks for the reply, they both helped.

-Minitman
 
1024 as measured in R1C1 notation, too.

Steve said:
Sorry, I'm wrong.

The maximung length of a formula contents appears to be 1,024 characters
Click to expand...
 
Which suggests that the other part of my original reply should have been

MsgBox Len(ActiveCell.FormulaR1C1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas In Cell Comments 9
Retrieving Part of a Cell Contents 6
Display Only Last 4 Characters If A Cell 2
Fix Broken Cell Formula with VBA 5
Extracting a Part of a Formula as Text 5
Test if Last Character in Column of Cells is Alpha Character 6
How Do I Check To See Id A Character Is Present In A Cell 4
Making A Nacro To Change The Contents Of Many Cells 4

Back
Top