Formula Length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Apparently I've exceeded the max number of characters. Is there an override?
 
Hi
no way around this limitation. But you may post your formula as there
may be better ways to achieve your goal. e.g.
- use defined names within your formula
- etc.

--
Regards
Frank Kabel
Frankfurt, Germany

rkowaluk said:
Apparently I've exceeded the max number of characters. Is there an
Click to expand...
override?
 
Use multiple cells.

If you refer to cells on other worksheets, use shorter worksheet names.

If you have the same range used multiple times, maybe you could use a defined
name to point at the range.
 
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

Max Length in a row 1
Importing text--cell text limit? 1
how to avoide duplicate entries in to cell 2
Counting characters 3
save as a .prn file 1
Conditional formatting to every cell in a column 7
file name length 7
Problem printing a large excel cell 5

Back
Top