Looking to delete partial entries from all cells in 2 different columns.
First part: one column has information such as "John Doe - Son" and I want to break it into 2 cells (adjacent columns)--one column with "John Doe" and the other column with "Son". Have many 100s of cells.
Second part: one column with phone numbers and other info in it (ex: 555-555-5555 - home, 444-444-4444 - work, 333-333-3333 - fax) and I only want to keep the first number. I realize I can find/replace the text and thus remove the words "home", "work", etc, but I want to get rid of the corresponding numbers as well. All I want is the first phone number, without any label. Also 100s of cells.
Any suggestions?
Thanks!
First part: one column has information such as "John Doe - Son" and I want to break it into 2 cells (adjacent columns)--one column with "John Doe" and the other column with "Son". Have many 100s of cells.
Second part: one column with phone numbers and other info in it (ex: 555-555-5555 - home, 444-444-4444 - work, 333-333-3333 - fax) and I only want to keep the first number. I realize I can find/replace the text and thus remove the words "home", "work", etc, but I want to get rid of the corresponding numbers as well. All I want is the first phone number, without any label. Also 100s of cells.
Any suggestions?
Thanks!