| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking text on the basis of condition
HI Every one
I have a list in two coloumns. First coloumn has country name alon with area name. Second is is country code with area code. I want to seperate country code from the area codes, evenif the countr name+ area name remains as it is. But i am unable to do so. here is example Country NAME Country CODE ALGERIA 213 ALGERIA Mobile 21361 ALGERIA Mobile 2137 AMERICAN SAMOA 684 AMERICAN SAMOA Mobile 6842 ANDORRA 376 ANDORRA Mobile 3763 ANGOLA 244 ANGOLA Mobile 244912 ANGOLA Mobile 244915 ANGOLA Mobile 244923 Now I want to make them in three coloumns Country NAME Country CODE Area CODE ALGERIA 213 ALGERIA Mobile 213 61 ALGERIA Mobile 213 7 AMERICAN SAMOA 684 AMERICAN SAMOA Mobile 684 2 ANDORRA 376 ANDORRA Mobile 376 3 ANGOLA 244 ANGOLA Mobile 244 912 ANGOLA Mobile 244 915 ANGOLA Mobile 244 923 see emaple attached as the above will not come properly formated o post. I will really apprecuate any help on this. Regards JK Attachment filename: example.xls Download attachment: http://www.excelforum.com/attachment.php?postid=41218 -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If condition with text | Excel Discussion (Misc queries) | |||
| sum if (text meets condition) | Excel Discussion (Misc queries) | |||
| Breaking a string of text | Excel Discussion (Misc queries) | |||
| split text in one cell into multiple cells without breaking the wo | Excel Worksheet Functions | |||
| breaking text in one cell into two cells | Excel Discussion (Misc queries) | |||
Threaded Mode
