Hi,
I have a list of names that contain a design name and the artist and looks like this
Design 1 BY Artist 1
What formula can I use to extract and separate all the data before and after the word BY so I have Design 1 in the 2nd column and Artist 1 in the 3rd column?
Thanks in advance for any help
Tahir
Bookmarks