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
|