hello

i have a cell with addresses and i want to split the address into hous
number and street name

for example cell C1: 123 Springfield Lane

split to
C1: 123
D1: Springfield Lane


thank

--
narutar
-----------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...fo&userid=2511
View this thread: http://www.excelforum.com/showthread.php?threadid=46825