I'm looking to copy text from a certain cell, probably assign it to a variable, and then paste it in another. The complication is that I only want a portion of text from the source cell. Specifically there will always be a chunk of text somewhere in the middle of this source cell; I want to grab all text to the right of this specific chunk of text. I suspect the MID function is involved, but I'm way too much of rookie to figure this out, because the number of characters before the specific chunk of text in the source cell will vary, and the number of characters to the right of the specific chunk (the ones I want to copy elsewhere) will also vary.
As an example, let's say the source cell is A1, and the text in it is:
BlueCHUNKElephant
CHUNK is the text that will always appear somewhere in the cell. The text I want to copy elsewhere is Elephant.
But in another case, the text in A1 is:
PurpleCHUNKAlbatross
In this case, Albatross is the text I want to copy elsewhere.
Any ideas? Thanks in advance!
As an example, let's say the source cell is A1, and the text in it is:
BlueCHUNKElephant
CHUNK is the text that will always appear somewhere in the cell. The text I want to copy elsewhere is Elephant.
But in another case, the text in A1 is:
PurpleCHUNKAlbatross
In this case, Albatross is the text I want to copy elsewhere.
Any ideas? Thanks in advance!