Max characters limit in formula

Chris Davison · Mar 24th, 2002, 05:13 AM

Morning all,

what's the maximium amount of characters allowed in a formula ?

1024 ?

(couldn't find anything in search, so apologies as I know this has been adressed more than once before)

thanks
Chris

edit - s'okay, I used =len after converting the formula to text and played around.... it does indeed look like 1024. No replies needed unless I'm wrong.

[didn't delete my original question either

]

[ This Message was edited by: Chris Davison on 2002-03-24 04:25 ]

Dave Hawley · Mar 24th, 2002, 05:49 AM

Hi Chris

Have a look under "Microsoft Excel specifications" in the help. Not sure if it's in there or not.

Aladin Akyurek · Mar 24th, 2002, 05:49 AM

Quote:

On 2002-03-24 04:13, Chris Davison wrote:
Morning all,

what's the maximium amount of characters allowed in a formula ?

1024 ?

(couldn't find anything in search, so apologies as I know this has been adressed more than once before)

thanks
Chris

edit - s'okay, I used =len after converting the formula to text and played around.... it does indeed look like 1024. No replies needed unless I'm wrong.

[didn't delete my original question either

]

[ This Message was edited by: Chris Davison on 2002-03-24 04:25 ]

Have a look at:

http://www.cs.umd.edu/class/fall2000...rs/SwFails.pdf

By the way, What formula did you try?

Aladin

Dave Hawley · Mar 24th, 2002, 05:50 AM

Chris, you are correct:

Re help:

Length of formula contents 1,024 characters

Chris Davison · Mar 24th, 2002, 07:38 AM

Quote:

On 2002-03-24 04:49, Aladin Akyurek wrote:
By the way, What formula did you try?

I was tinkering with an earlier question about converting numbers to textual numbers (324 = "three hundred and twenty four") trying to squash it all into a single formula

still am tinkering

Chris

Jack in the UK · Mar 24th, 2002, 02:52 PM

Hi mate.. sorry been super busy catch up ASAP or cal me at work if needs be ICQQ??? Ill sort it sure

Look simple ten twenty four max .. sorry to post late, you fine characters max text and charracters formula are a right 'ole pain.. not always correct count spaces and new lines and all sort.

Just a tip to add and my point of posting this use rows to convert once new row convert twice new row new row.. keeps it all in contol and simple step by step, and edit easy .

When got reqd result .. copy paste special and delete all the redundant row or prob columns depends which way your going of cause.

just a tip chris..

catch up asap

Chris Davison · Mar 25th, 2002, 02:06 PM

thanks mate, I was using columns for each step...

my rows were to check the numbers as they changed

Tricky one this...!

Mar 24th, 2002, 02:52 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi mate.. sorry been super busy catch up ASAP or cal me at work if needs be ICQQ??? Ill sort it sure Look simple ten twenty four max .. sorry to post late, you fine characters max text and charracters formula are a right 'ole pain.. not always correct count spaces and new lines and all sort. Just a tip to add and my point of posting this use rows to convert once new row convert twice new row new row.. keeps it all in contol and simple step by step, and edit easy . When got reqd result .. copy paste special and delete all the redundant row or prob columns depends which way your going of cause. just a tip chris.. catch up asap __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 05:13 AM	#1
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Morning all, what's the maximium amount of characters allowed in a formula ? 1024 ? (couldn't find anything in search, so apologies as I know this has been adressed more than once before) thanks Chris edit - s'okay, I used =len after converting the formula to text and played around.... it does indeed look like 1024. No replies needed unless I'm wrong. [didn't delete my original question either ] [ This Message was edited by: Chris Davison on 2002-03-24 04:25 ]

Mar 24th, 2002, 05:49 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Chris Have a look under "Microsoft Excel specifications" in the help. Not sure if it's in there or not.

Mar 24th, 2002, 05:50 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Chris, you are correct: Re help: Length of formula contents 1,024 characters

Mar 25th, 2002, 02:06 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	thanks mate, I was using columns for each step... my rows were to check the numbers as they changed Tricky one this...!