Format is too long

Well issue is I am wanting to find and replace text in workbook. I enter my find " Monday" and my replace "xxx Monday". Pressing FIND NEXT finds the text. Pressing REPLACE brings back the box stating "Formula is too long".
I have searched looking for solution, to only find references to actual formulas.
Doing a little trial and error, I believe I discovered why I get this. It looks like the contents of the cell is too large/long. I have not determined the size that it bombs out at. So having to go to each large cell and manually change.

If anyone has feedback on this, great!

Thanks

Pressing REPLACE brings back the box stating "Formula is too long".

https://support.microsoft.com/en-us/...7-269d656771c3
Excel 2007 thru O-365:

• Length of formula contents 8,192 characters
• Total number of characters that a cell can contain 32,767 characters

If you are really still on Excel 2002 as your profile says:

https://www.excelforum.com/excel-gen...ml#post2200894
Yes, formula can be too long - here's a quote from the Excel 2002 Help files:

• Length of formula contents 1,024 characters
• Max length of cell text: 32,767 (but only 1024 are displayed in the cell)

Yes, still using Excel 2k on Win 2K & Win 10. I would agree that the contents of cell that the Replace does not work with is >255. Have not reached the max of text in cell.

Thanks to all who have replied. Appreciated. Happy Holidays to all!!

Glenn,

I believe with my cell containing text that is >255 characters Excel errors out.
I uploaded TEXT-Book2.xls. As an example, I am wanting to change /19 to /2019. But excel error out. I have to make change manually.

I did try another test and could change text for cell > 255. Do not know what the difference is and why one works but the other test did not.

Good luck. Maybe you might have an idea.

Thanks for looking. Sorry it's taken me so long to get back to you.

Well that is interesting that it worked for you. However, I still get the Format is too long.
However, Thanks for the feedback.

I guess I'll just have to be happy doing manual changes.

Thanks again to all. Happy Holidays..

My issue is not SOLVED. However, the thread can be CLOSED. I do not know how to do that. Please advise.