Комментарии:
In the second example you had a comma after each word, but that's not how most address data sets appear. How would you split this data into the following columns: Street Number and Address; City; State; and Zip Code? For example, 112 Surrey Ave should be kept as one cell, then the remainder of the cells should be split individually. How would you split cells that contain two-word or three-word city names, like Grand Rapids, Michigan or Salt Lake City, Utah?
ОтветитьHow do I do this manually? I just want to create more cells under a bigger cell, like you can in Excel.
Ответить