Thread: Splitting a cell that contains two names seperated by /

Hi There,

I have a cell that contains two people names that separated by /

I can use the text to columns on menu bar to get this done, but is there a way using a text formula to separate the names into two separate columns.

Col A Col B Col C

Joe Blogs / Tim Angel Joe Blogs Tim Angel

Col D Col E
Joe Blogs Tim Angel
=LEFT(a1,FIND("/",a1)-1) =TRIM(RIGHT(a1,FIND("/",a1)-1))

But is there away of combining two formulas into one, and

Regards Husfay

Hi Arthurbr

i marked it solved as it only two ways of getting this solution resolved, one is by using the ribbon to get the text to columns into two seperate columns by delimintors, and the other one is using the two formulas i had done, but there was somewhere i had told me that it can be done, but this was 2 and half years ago, and the life of me i think what was method, if any one knows using any means of using excel formulas, vb,

Share your knowledge

husfay