Asked • 08/04/19

Copy comma delimited values into two excel cells?

I have comma delimited values that look like : 17 ab 2880662,2880663 15 ab 2877244,2877247 21 ab 2874201 21 ab 2873876When I copy this to Excel it should split the comma-delimited values into two cells, like this: 17 ab 2880662 2880663 15 ab 2877244 2877247 21 ab 2874201 (empty) 21 ab 2873876 (empty)When I use copy as a text it doesn't work, so I need a genius idea please :)

2 Answers By Expert Tutors

By:

Quang T. answered • 08/04/19

Tutor
5 (19)

GIS Professional with experience in Python and Engineering concepts

Michael P. answered • 08/04/19

Tutor
4.9 (261)

Knowledgeable, Professional, Enthusiastic, Accessible, and Effective

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.