Separation names in Excel use Text to Columns Wizard
I often by using the Text to Columns Wizard. It provides options for splitting the data which returns great results every time I use it. Step 1: select the area containing the data, and then move to DATA menu, and click “Text to columns” or as shown below Step 2: We select “Delimited” and then click “Next”
Step 3: Default MS office select “Space” and then click “Next”
Step 4: Then click “Finish”
I wish you success.
See more:
Separation names in Excel use “Flash Fill”
Beware of hacker tricks when openning the documents
Split names into first, last, and middle, separate titles and name suffixes use add-in
Lượt xem (474)
Để lại bình luận: