donlincolnmre2
Board Regular
- Joined
- Dec 23, 2006
- Messages
- 142
Hello
I have a spread sheet with bunch of raw data and its all in colum A, within that data there are 4 fields, Name, address, city state zip, phone number, I'm looking to extract that information from column A in to column, b, c, d, e, the macro suppose to grab that text from those 4 rows and just make 1 row, and placed that data in Column B, C, D and E
here is the data.
Oklahoma l
Oregon l
Pennsylvania l
Rhode Island l
South Carolina l
South Dakota l
Tennessee l
Texas l
Utah l
Vermont l
Virginia l
Washington l
West Virginia l
Wisconsin l
Wyoming l
Lint, Michael G
2917 Ninth Ave
Sacramento, CA 95818-4046
(916) 446-4218
Find Neighbors l
Map and Driving Directions l
Printer-Friendly l
Send Listing to my Email l
Find Nearby Businesses l
Type: Land Line
SPONSORED LINKS
Listing date Nov. 2009
Local Information for Sacramento, CA
Population: 407,018 l
I have a spread sheet with bunch of raw data and its all in colum A, within that data there are 4 fields, Name, address, city state zip, phone number, I'm looking to extract that information from column A in to column, b, c, d, e, the macro suppose to grab that text from those 4 rows and just make 1 row, and placed that data in Column B, C, D and E
here is the data.
Oklahoma l
Oregon l
Pennsylvania l
Rhode Island l
South Carolina l
South Dakota l
Tennessee l
Texas l
Utah l
Vermont l
Virginia l
Washington l
West Virginia l
Wisconsin l
Wyoming l
Lint, Michael G
2917 Ninth Ave
Sacramento, CA 95818-4046
(916) 446-4218
Find Neighbors l
Map and Driving Directions l
Printer-Friendly l
Send Listing to my Email l
Find Nearby Businesses l
Type: Land Line
SPONSORED LINKS
Listing date Nov. 2009
Local Information for Sacramento, CA
Population: 407,018 l
