If he has commas as he shows, he can use that as the delimiter.

--
HTH

Bob Phillips

"Rowan" wrote in message
...
One way:

Select the data and then use DataText To Columns. Check Delimited and
Space as the delimiter. You may however run into problems where you have
spaces in the city name eg "New York"

Hope this helps
Rowan

jayceejay wrote:
I have an "Address" field in Excel that houses Street address, City,
State, &
Zip, separated only by spaces. How do I go about separating strings
into New
fields for City, State, and Zip? Is there some kind of VBA code I can
use to
separate the larger string?