CODEWITHSUNDEEP
excelgoogle-sheets
jd006
jd006

Reputation: 9

What delimiter do I use to separate the string in this cell

I have a database with this type of cell formatting in Google Sheet/Excel:

7-1024000032376
4-2512000032300
4-5902000032386

Cell sample:

enter image description here

I need to separate each string into a separate row, and not sure how to do it as there is no delimiter, nor a blank space. The no of character in each string varies between 14-16 character, so separate by fixed width doesn't work 100% of the time. Thank you for your help

Upvotes: 0

Views: 49

Answers (2)

Ozgun Senyuva
Ozgun Senyuva

Reputation: 466

Not a hi-end solution but this had worked for me before. pls try:

copy your excel column,

paste it to notepad,

then copy data you pasted in notepad and paste it to a word doc,

then copy data you pasted in word doc and paste it to excel.

Upvotes: 0

Ferrariic
Ferrariic

Reputation: 61

On Google Sheets: Highlight the text > Data > Split Text into Columns > Space Delimiter, then Copy the text > Paste special > Transposed

Upvotes: 1

Related Questions