I need to scan my worksheet for a value of:
and replace it with:
The problem is, my cells exceed 1024 characters and I cannot use find and replace. I know the data exists, however it does not find it for replacing.
I do have expresso for composing reg ex strings, but I am not sure how to create a replace string. I will also need to do this for about 100 other entries.
I will be searching column E of my excel file, sheet 'jos_content'.
My find string will be on column B of my excel file, sheet 'FandR'
My replace string will be on Column C of my excel file, sheet 'FandR'