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

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

7-1024000032376
4-2512000032300
4-5902000032386

Cell sample:

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

CodePudding user response：

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

CodePudding user response：

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.