Just paste as it is and goto Data>Text To Columns>Deliminated>Next>(Select)Tab/Semicolan/Comm/Space>Next>(Select your preference in column data format)
If the state is all the same, type the state in one cell, then highlight that and drag down over all the other cells you want it in. then click on edit > fill > down
It relies upon the kind you to show it. this could integrate your archives right into a single textual content fabric string. In A11 placed =A1&A2&A3&A4&A5&A6&A7&A8&A9&A10 and drag this formulation around the 14 columns. you ought to placed an area between each and each cellular with =A1&" "&A2 (etc.)
Answers & Comments
Verified answer
Depends. Do you have a separate column for state, or will state go in the same cells where city is (more difficult)?
Is your paste source another spreadsheet or something else?
Just paste as it is and goto Data>Text To Columns>Deliminated>Next>(Select)Tab/Semicolan/Comm/Space>Next>(Select your preference in column data format)
If the state is all the same, type the state in one cell, then highlight that and drag down over all the other cells you want it in. then click on edit > fill > down
It's even easier than that. Just highlight all of the cells at once and Paste.
It relies upon the kind you to show it. this could integrate your archives right into a single textual content fabric string. In A11 placed =A1&A2&A3&A4&A5&A6&A7&A8&A9&A10 and drag this formulation around the 14 columns. you ought to placed an area between each and each cellular with =A1&" "&A2 (etc.)