View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Separating numbers and words into separate columns

You oughtn't to type the formulae, just copy and paste them from here, and
then adjust any cell references accordingly. Retyping is too prone to
error.
--
David Biddulph

"Windy" wrote in message
...
I can't thank you enough-once my fingers actually typed the formulas
correctly, it worked great!
Windy

"Roger Govier" wrote:

Hi

With data in column A, enter in B1
=IF(ISNUMBER(A1),A1,"")
and in C1
=IF(ISTEXTA1),A1,"")
Copy down as far as required

--

Regards
Roger Govier

"Windy" wrote in message
...

Sam Jones
5/9/2007 This info is all in one colum; how do I place the Sam
Jones dates in one column and the names in
Mary Smith another?
4/30/2007
Mary Smith