To separate parts of an address or dat

Question

English

Urijah Kaufman

6 December, 00:41

To separate parts of an address or dat

+4

Answers (1)

Know the Answer?

Isabela Arroyo · Answer 1

Separate the Two Lines into Two Separate Columns

Make sure there is an empty column to the right of the address ...

Select the column with the addresses in it ...

Select the text to columns function from the data menu.

When the text to columns wizard opens, select Delimited and click Next.