View Single Post
  #5   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

Okay, I do have another question about this. I worked the formulas in my
spreadsheet and copied them down. Then I copied the columns and did a paste
special values to have the names in the column, not the formulas. Now I need
to copy the names into the blank spaces and it won't let me because Excel is
not finding "blanks" between the names because of the formula. So, now how
can I copy the names?

"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