Please help with formula. I have the following in Column A
01. Artist - Title
I manage to put 01 in Column B and Title in Column D
I am struggling to split between the "." and the "-" to show Artist in Column C
I am using in Column B
and in Column D![]()
=IF(A1="","",LEFT(A1,FIND(".",A1)-1))
![]()
=IF(A1="","",RIGHT(A1,LEN(A1)-FIND("-",A1)-1))
Bookmarks