Split

[Ashwini]

Hi,

Dr. J. P. Mathur 09414343473 Phone : Fax :
Mr. Nitesh Dangi 098410 72060 Phone : Fax : 44)-52053466
S.GUHA ROY Phone : 913324015952 Fax : 913324017311
Mr. Somaraju Srikanth 09848028145 Phone : 40-23078309 / 23073795 Fax :
40-27959666
Mr. Abhay Kumar Phone : 121-2440130/ 2440131/ 2440132/ 2440028 Fax :
121-2440218

Above all entries are in single column, how do I split into different
columns for Contact Person, Phone & Fax.

Pl. help me.

 

[Jacob Skaria]

Try the below with the data in ColA

In B1
=LEFT(A1,FIND("Phone :",A1)-1)

In C1
=SUBSTITUTE(LEFT(A1,FIND("Fax :",A1)-1),B1,)

In D1
=SUBSTITUTE(A1,B1 & C1,)

PS: There is a number along with the name.

If this post helps click Yes