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?(a) Excel inserts new columns for each comma so the phone number will move to column G.
(b) The phone numbers are overwritten by the cities.
(c) Nothing will happen to the phone numbers.
(d) The phone numbers will convert to commas.