Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split up | New Users to Excel | |||
How do I remove split a split window? | New Users to Excel | |||
Un-Split | Excel Discussion (Misc queries) | |||
split bar | Charts and Charting in Excel | |||
Split a Value | Excel Discussion (Misc queries) |