MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Splitting up columns


Posted by Edie on February 15, 2002 9:47 AM

Its me again,
Thanks for all the help yesterday.
But now I am trying to split up the address field.
I can get the numbers out but cannot get the street and Suffix out.
Example
10 Westchester Ct
102 Crab Tree Ln
1002 N 50 E
106 N Couty Rd 50 W
1066 S Baums Bridge Rd
1068 N 100 E
Is there a forumla that will delete the first numbers?


Posted by Mark W. on February 15, 2002 9:52 AM

Just use the Data | Text to Columns... menu command [nt]