Is there a way around the 1024 character limit in a cell

[1Roberta1]

Hi I was wondering if someone could tell me if there is a way around the 1024 character limit in a cell Excel 2000.

I know that the formula bar holds 32.000+ characters but will only show approx 1024 in the cell and will only print out aprrox 1024.

I have converted my excel sheet into word so that I can display more characters, however i am missing/needing some of the functions that excel allows, it would be great if there was a way around this limit.

Can anyone help? Or was my option for converting it to word the only solution?

Thanks in advance for your time.

 

[Richard Schollar]

Hi

You would have to split your text between cells (there's no way around the limit, altho you can actually get slightly more than 1024 characters in a cell dependent on the font and text size).

 

[1Roberta1]

Thanks for your prompt response. I will try making my font smaller if that doesn't fix it I will look at splitting the text. (Thats something else I learnt from this forum )

You guys/girls are great.

Thanks again for your response is much appreciated

Hopefully someday soon I will be able to contribute and help out other people here too.

 

[Richard Schollar]

You're welcome

When i say you can get slightly more, I really do mean only slightly eg you might be able to get 1100 characters instead, so this may well not be that useful to you.

 

[alphadown]

What about text boxes? You just need to enable the Drawing toolbar to get the button for it.

 

[1Roberta1]

Excellent I will remember that for future spreadsheets that I create. (Back converting is not really an option now just because of the amount of work that I have already completed)

I will be able to use both Richards and your method for different sheets that I need to create each month.

Thanks again