Need data in separate columns

[Abhirockie]

HI Professionals,

I have a huge data and i am looking for some help, if someone can help me it would be really great. I have below date in one column. I need the date to be shown in three different column. I am not sure if this is going to happen in excel ?? If Yes, Please let me know if not any suggestions are greatly accepted. !!

I have DATE IN COLUMN A I NEED TO SAPERATE IN EXACTLY 3 COLUMNS !

ACTUAL	EXPECTING
Woodside, NY, 11377	Woodside,	NY,	11377
Manhattan, NY, 10001	Manhattan,	NY,	10001
Manhattan, NY, 10001
Manhattan, NY, 10001
Corona, Ny, 11368
Hoboken, NJ, us, 07030
Jersey City, NJ, 07097
New York, NY, us, 10005
Jersey City, NJ, us, 07097
Parsippany, NJ, 07054
Somerset, NJ, 08873
Wharton, NJ, 07885
Edison, NJ, 08837
Edison, NJ, us, 08837
New York, NY, us, 10019
Long Island City, NY, 11103
Midtown East, NY, 10155
New York, NY, in, 10001
Manhattan, NY, us, 10001

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[Gary's Student]

Do you want to discard the country (us) if it is present ??

 

[My Aswer Is This]

Select Column "A" and then from the ribbon choose:
"DATA" then choose "Text To Columns" then choose comma Delimited.

 

[Rick Rothstein]

Select Column "A" and then from the ribbon choose:
"DATA" then choose "Text To Columns" then choose comma Delimited.

That would leave leading spaces in the second and third columns that get filled plus it will remove the commas (the OP shows the commas being retained after the split). So, before your Text To Columns suggestion, I think using Excel's Replace dialog box to replace each "comma space" with, say, "comma slash" and then performing the Text To Columns using the slash as the delimiter would produce the result the OP says he wants. I would point out that Gary's Student asked an important question as the OP's answer could impact the Text To Columns suggestion.

 

[Abhirockie]

Do you want to discard the country (us) if it is present ??

CITY AND STATE IS IMPORTANT for me. I dont mind with COUNTY coz all my data is in UNITED STATES ..

 

[Abhirockie]

It worked

Such an Excellence. Much Gratitude.. GoodNight. !

enjoy the Weekend. !

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

It worked

Such an Excellence. Much Gratitude.. GoodNight. !

enjoy the Weekend. !

 

[Abhirockie]

Thank you for your suggestion. I will make sure on that !