A workbook contains addresses in column C. The addresses use commas after the street, city, and…
A workbook contains addresses in post C. The addresses use commas following the street, city, and avow, such as 129 Elm Street, Burlington, NC, 27215. Post D contains the phone sum. You command Excel to allot the grounds into multiple posts using comma delimiters. You successfully allot the post into impure posts. What occurs to the phone sums in post D?
(a) Excel inserts new posts for each comma so the phone collection achieve instigate to post G.
(b) The phone sums are overwritten by the cities.
(c) Nothing achieve occur to the phone sums.
(d) The phone sums achieve be converted to commas.