View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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