Move only numbers to a new column
Thanks for the attempt, but it doesn't seem to be looking for numbers only.
Instead it only copies and pastes whatever is in column A to B.
"bj" wrote:
potentially in B1 enter =if(A1<"",A2,"")
copy and paste down.
copy column B and paste special values
This assumes there is a blank line between groupings.
"Outlook, eh?" wrote:
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
|