View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Windy Windy is offline
external usenet poster
 
Posts: 19
Default Separating numbers and words into separate columns

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