Copy comma delimited values into two excel cells?

Question

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 :)

Answer 1

Use the [Text to Columns] tool found under the [Data] tab.

From there, it provides you an option on how you want to separate the information in your cell. Delimited separates them by specific parameters (e.g. space, commas, etc.) while fixed width separates them by the position of the text in the column.

I am assuming that when you paste it, the info is in one column rather than just one cell.

Answer 2

The Excel Cut-Copy-Paste feature uses a tab character as the marker to break a string of characters into a series of adjacent cells. I cannot find a reference to indicate that Excel uses any other character as a similar marker. The tab is the traditional inter-cell delimiter for tables, so there might not be additional characters that are used to delimit cells in the row of a table.

Once you have pasted a string into any cell, you can use the Text to Columns feature under Data to further separate the string across cells at other characters such as the comma.

Search for split-text-into-different-columns-with-the-convert-text-to-columns-wizard under support.office.com.

You can also use the Find and Search functions to find the commas in a cell and the Len, Left, Mid, and Right functions to separate the parts of the string into new columns.