rossww wrote:
i have a vertical list of over 8000 names and phone numbers, the problem
is they are all in one cell.. ie

Fund for District Nurses 01793 554200

is it possible for me to apply a process to all these cells that would
copy all the telephone numbers out of the original cell and stick them
in a new one? all the numbers are different, all the text in the cells
are different.

THANKYOU!!!!


--
rossww
------------------------------------------------------------------------
rossww's Profile: http://www.excelforum.com/member.php...o&userid=36742
View this thread: http://www.excelforum.com/showthread...hreadid=564613

Hi,

If all the phonenumbers are at the end of the text in the cell then you
can use something like this:

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&{0,1,2 ,3,4,5,6,7,8,9})),1024)

If your list starts in A1 then put this in B1 and just copy down the
length of your list.

Regards,
Bondi