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