Help Needed

[KENW]

I HAVE ATTACHED A SAMPLE, CAN SOMEONE HELP ME ACHIEVE THE RESULTS IN COLUMNS B,C,D THE CITY,ST,ZIP ARE ALWAYS IN THE SAME FORMAT. I HAVE 100'S OF ENTRIES THAT NEED TO BE STRIPPED OUT.

THX

SO

MUCH

KEN

 

[bobhc]

Use text to columns.

 

[KENW]

FIRST THX FOR RESPONDING BUT I DON'T UNDERSTAND YOUR RESPONSE

 

[bobhc]

Have you looked at Text to Columns?

Turn of your caps key, it is annoying to have SHOUTY upper case

 

[bobhc]

Text to columns, takes just a few clicks of the mouse, choose your data, column A, then open up Text to Columns, choose delimited and on the text screen choose semi colon and space, select where you want the data and then click finish, format columns as needed.
Text to columns can be found in the Data Tools which are in the data tab of the ribbon.
See the upload

 

[Hui]

@Ken

We know you need help that's why your asking a question here

Please use descriptive Titles so that people with particular skill sets can home in on your question or avoid it if they are unfamiliar with that issue

I would like to direct you to the post: New Users Please Read
http://chandoo.org/forum/threads/new-users-please-read.294/
where the site rules are explained

Use of CAPS is not recommended, it turns people off

 

[deciog]

KENW

After all I like to help

B1 =MID(A1,1,FIND(",",A1)-1)

C1 =MID(A1,LEN(B1)+3,2)

D1 =RIGHT(A1,5)

Decio Brazil, City São Paulo State São Paulo