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]
