Assume that your data is in a1 cell like the below.

A1 cell
name-name2

Copy and paste the below formula in B1 cell
=IF(A1="","",TRIM(LEFT(A1,FIND("-",A1)-1)))

Copy and paste the below formula in C1 cell
=IF(A1="","",TRIM(MID(A1,FIND("-",A1)+1,255)))
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Going Crazy with excel" wrote:

I am using text to column.
Have name-name2
They are separated by a "dash". Want them in two separate columns.
What do I put in the destination cell?