Split
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
---------------
Jacob Skaria
"Ashwini" wrote:
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.
|