A worksheet contains addresses in column C. The addresses use commas after the street, city, and state, such as 129 Elm Street, Burlington, NC, 27215. Column D contains the phone number. You use Text to Columns to divide the addresses into multiple columns using comma delimiters. You successfully divide the addresses into four columns. What happens to the phone numbers in column D?

Question

Guest

21 February, 14:14

+3

Answers (1)

Know the Answer?

Bailey Francis · Answer 1

The phone numbers are overwritten by the cities.