View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Outlook, eh? Outlook, eh? is offline
external usenet poster
 
Posts: 35
Default Move only numbers to a new column

Frustratingly enough a user created a column like:

A
Bill Hicks
3261 Austin Street

Daniel Johnston
1717 Yip Jump Way

I would like to move only addresses to column B, thus it would be:

A B
Bill Hicks 3261 Austin Street

Any help would be most appreciated!
-B