Jim Metcalf
asked on
Can someone figure this out for me.
I have a column with addresses. It has the st number and the street name... all in the same cell
I need to divide it up by street number and then street name. I also need the street name to be all capitalized which currently it is not
what I have
column a
144 main st
1789 elm st
what I would like
Column a column b
144 MAIN
1789 ELM
I need to divide it up by street number and then street name. I also need the street name to be all capitalized which currently it is not
what I have
column a
144 main st
1789 elm st
what I would like
Column a column b
144 MAIN
1789 ELM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014