petersona01
New Member
- Joined
- Sep 30, 2011
- Messages
- 11
Is there a cutting formula to cut out unwanted info in a cell? Example;
Cell 1= 1009 Dauphin St, Mobile, AL 36604 » Map (251) 438-4729
Cell 2= 401 3rd Ave, Ashford, AL 36312 » Map (334) 899-4636
Can I cut everything after the zip code to look like this below
Cell 1= 1009 Dauphin St, Mobile, AL 36604
Cell 2= 401 3rd Ave, Ashford, AL 36312
Thank you in advance
Cell 1= 1009 Dauphin St, Mobile, AL 36604 » Map (251) 438-4729
Cell 2= 401 3rd Ave, Ashford, AL 36312 » Map (334) 899-4636
Can I cut everything after the zip code to look like this below
Cell 1= 1009 Dauphin St, Mobile, AL 36604
Cell 2= 401 3rd Ave, Ashford, AL 36312
Thank you in advance