Hi,
I have text in a cell in the following format:
"Country 1: Text"
The number of the country may be 1, 2, 3 or 4.
Can someone please suggest a formula to extract the text after the colon and following space. i.e. "Text" in my example?
Thanks!
Hi,
I have text in a cell in the following format:
"Country 1: Text"
The number of the country may be 1, 2, 3 or 4.
Can someone please suggest a formula to extract the text after the colon and following space. i.e. "Text" in my example?
Thanks!
Last edited by andrewc; 07-15-2020 at 10:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks