Hi All,
I would like some help on trying to figure out how to perform the following:
In cell A1 I have the following format of data:
"Performance: Improvement
Performed by: Joe Bloggs"
Essentially, I would like to pull the text just after 'Performance:' part and also pull the text just after 'Performed By:'
This will help me understand if the text is left blank just after 'Performance:' & 'Performed By:'
There is no specific amount of characters that will be after the 'Performance:' & 'Performed By:', this will vary.
Any ideas on how this can be done?
Thanks in advance
I would like some help on trying to figure out how to perform the following:
In cell A1 I have the following format of data:
"Performance: Improvement
Performed by: Joe Bloggs"
Essentially, I would like to pull the text just after 'Performance:' part and also pull the text just after 'Performed By:'
This will help me understand if the text is left blank just after 'Performance:' & 'Performed By:'
There is no specific amount of characters that will be after the 'Performance:' & 'Performed By:', this will vary.
Any ideas on how this can be done?
Thanks in advance