| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Semicolon problem
Hi, I've got some data which i imported from a text file The data constains company names adrresses and telephone numbers Now the problem is, in the text file some of the semicolons are in th wrong place. When i import it into excel i want to move the semicolon so that space belongs where they must, example imported into excel: (Semicolon where space should be) TFS Securities (Pty) Ltd;Sandton;Gauteng;011 465 3686 Vector Equities (Pty) Ltd;Cape*;*Town;Western Cape;021 419 3992 Watermark Securities (Pty) Ltd;Hyde*;*Park;Gauteng;011 325 4228 Cazenove South Africa (Pty) Ltd;Dunkeld;West*;*Gauteng;011 280 7900 The first one is correct but the last 3 needs changing: Vector Equities (Pty) Ltd;Cape Town;Western Cape;021 419 3992 Watermark Securities (Pty) Ltd;Hyde Park;Gauteng;011 325 4228 Cazenove South Africa (Pty) Ltd;Dunkeld;West Gauteng;011 280 7900 As you can see this is a dillemma. I'm trying to automate the change with a macro, but some of the length clash and then i had a space where it doesnt belong. I would appreciate the help. Thanks in advance. Pete -- MavRi ----------------------------------------------------------------------- MavRiK's Profile: http://www.excelforum.com/member.php...fo&userid=1472 View this thread: http://www.excelforum.com/showthread.php?threadid=26504 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I add a semicolon at the end of a name in 400 rows at once | Excel Discussion (Misc queries) | |||
| adding a semicolon | New Users to Excel | |||
| Adding a semicolon to the end of a name | Excel Discussion (Misc queries) | |||
| SUMPRODUCT --- semicolon (;) vs. plus sign (+) | Excel Worksheet Functions | |||
| how do i make a semicolon appear in every cell | Excel Discussion (Misc queries) | |||
Threaded Mode
