Kamis, 26 Oktober 2017

[ExcelVBA] Separating House # and street name currently in one column

 

I have a list of about 4000 addresses that currently have the house number and street name together in a column/cell. I need to separate them so that the house number is in one column and the street name is in the adjacent column.


I think I have seen this problem in topics several years ago, but cannot find it. Can anyone help out. I have tried recording Macros, but it keeps repeating the street name from the first record.


Mark

Austin, TX

__._,_.___

Posted by: maxwells@swbell.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

.

__,_._,___

Tidak ada komentar:

Posting Komentar