Hello Excel Experts,
^[Ss][Oo][Cc][Ii][Aa][Ll] + ?[Rr][Oo][Aa][Mm] [0-9]+ ?$
I need to return the above as SOCIAL ROAM.
Anyone can help, pls?
Thousands in a list to do. Thought of formula would be fast solution. If can get the right one.
Appreciate your help.
Thanks in advance.
DZ
Bookmarks