Hi everyone,
Im currently making a database by copying fields from another database,
and I have some problems with separating numbers and letters.
An example of what im trying to do is-
Trying to split

UNIT 7 5-9 WOON GARDENS
24 RYDER ROAD
6 JESTER COURT
11 GRADER ROAD
4 ALEN PLACE
7 WILENSON LANE
UNIT 1 FAR ROAD
SHOP 771 CANTON HWY

So there are 2 different cells. One containing the writing upto and
including the last number, and one with the remaining.
For example

Column A
UNIT 7 5-9
24
6
11
4
7
UNIT 1
SHOP 771

Column B
WOON GARDENS
RYDER ROAD
JESTER COURT
GRADER ROAD
ALEN PLACE
WILENSON LANE
FAR ROAD
CANTON HWY

Is this actually possible? I tried text to columns, but that didn't
really work too well. Any Ideas?
Thanks,
Andrew


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php...o&userid=21390
View this thread: http://www.excelforum.com/showthread...hreadid=379592