split text and numbers into separate cells
On Tue, 1 Sep 2009 04:14:02 -0700, Julie
wrote:
Hi everyone
I have a column that has text and numbers (name and phone number) in example
Julie 01264 000000.
I need to be able to split out the telephone number into another column can
anyone help?
Thanks in advance
Julie
So long as there are no digits within the name:
A1: Julie 01264 000000
Name:
=TRIM(LEFT(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1& "1,2,3,4,5,6,7,8,9,0"))-1))
Digits:
=MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&"1,2,3 ,4,5,6,7,8,9,0")),99)
--ron
|