Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Having trouble sorting addresses in excel 1
- Thread starter tripp2222
- Start date
-
1
- #2
SkipVought
Programmer
Hi,
you'll have to parse your address into 2 columns.
Check out Date/Text to columns...
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
you'll have to parse your address into 2 columns.
Check out Date/Text to columns...
Skip,
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering... "Is there really a DOG?"
SkipVought
Programmer
oops...
I meant to type...
menu item Data/Text to columns...
Skip,
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering... "Is there really a DOG?"
- Status