last name: =LEFT(C2,SEARCH(",",C2)-1)
first name: =RIGHT(C2,LEN(C2)-SEARCH(",",C2)-2)
number: =LEFT(D2,SEARCH(" ",D2)-1)
street: =RIGHT(D2,LEN(D2)-SEARCH(" ",D2)-2)

Regards,
Stefi

€žTemplar€� ezt Ã*rta:

Could someone please provide me with a step by step procedure for the
following "column problems"?

In column C I have the Owner's Name beginning with
the last name, then a comma and then the first name(s).
I would like to put the last name to the left of the comma in
one column and the first name(s) to the right of the comma in
a separate column.

Further down below is a different column problem: COLUMN D

COLUMN C
Owner Name
POWERS, DAVID
KAZYAK, SHANNON & BRIAN
BAYER, EMILY
OBERHOLTZER, KARLA
GILBERT, ELYSE/BRIAN
HILL, DAVID
SICILIANO, DIANA
ZUCKER, JAMES, JOY
MURPHY, WILLIAM
LUPO, DAVID
MENDEL, JONATHAN
YATES, SUSAN
DEVONE, CARRIE
HAYS, RYAN
PHIFER, ROY & KAREN
FARLEY, BARBARA
MORGAN, SHARON & JIM


Below in COLUMN D, I would like to put the number itself in one column and
everything to the right of the number in its own column

COLUMN D
StreetAddress
1122 N LOMBARD AVE
705 N HUMPHREY AVE
1221 N RIDGELAND AVE
1021 N EUCLID AVE
1131 WOODBINE AVE
521 S GROVE AVE
224 LAKE ST
1032 N EAST AVE
332 S EUCLID
538 N EAST AVE
112 S TAYLOR
1175 HOME AVE
42 LAKE
12 W HARRISON
833 N EUCLID AVE
825 WOODBINE AVE
1229 HAYES AVE

Thank you.
--
Templar