Finding a specific character and moving the selection to a column if present.

[Jkellen]

Hi,

I am working from an excel file with emails and names mixed in the same column. In order to separate the two I have used text to columns and then I wish to search these columns for the presence of the "@" character, so that I can then append emails into one column (contacte emails) and Names into another (contact names new).

My current method was using the formula:

IF Contains([Contact Names1],"@") THEN [Contact Emails] ELSE [Contact Names New] ENDIF

[MilindG]

Does this hlelp?