Split
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. |
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. |
All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com