Find/Replace after 8,192 Character limit

[honeyhany]

Has anyone ever tried to do a replace of any phrase/string in a cell that contains more than 8,192 characters limit (replacing something after that mark), using wildcards?

For example, if the string "Has anyone ever*characters limit" was to be replaced after the 8,192 character limit, how can this be implemented?

I've tried in Office 2007 and 2013 to no avail. Please see attachment for example.

Could I offer a couple of drinks for your help via Paypal? Thank you.

[pwnyadav007]

u can use this formula to replace "Has anyone ever" to "new text" in A2 cell
=REPLACE(A1,FIND("Has anyone ever",A1),LEN("Has anyone ever"),"new text")

after that copy A2 cell and paste as a value only in A1 cell and then delete A2 cell formula

Hope this will help u

[newdoverman]

You can use the SUBSTITUTE function

=SUBSTITUTE(A1,OLD TEXT,NEW TEXT)

I tried it with the text in A1 and the formula in A2. I then copied A2 and pasted into a Text Box and the substitution had been made.

[honeyhany]

Hi everyone, thank you for taking a look.

It doesn't seem you are trying any string with a wildcard, that's my issue. See my example below (with the "*" character in the original document I attached:

"Has anyone ever*characters limit"