Split text and numbers in a text string

[bear1]

I want split/separate a text string into Text and Numbers

Example: [FONT=&quot]Hafnia Nordica S/B 49.999 59.100 2010 off Amsterdam 25. Sep UKC 25. Sep ums/nap/jet

I want to split numbers and text into different columns.

Please help[/FONT]

 

[bear1]

I thought it was a bit cheeky to ask about Google Sheets on an Excel forum. I'm more pro Excel anyway. Thank you for all your help. I will continue trying to find solutions to this.

 

[bear1]

Hi Peter, how are you?

I have another Text to Columns problem i want to solve. It's very similar to the last one but the column layout is different.

I want to split the follow text strings into columns. Below I have written the delimiters:

Alpine Persefone LR1 74,500 Sungdong 2008 13,500 Navig8 1 Year

Archangelos Gabriel LR1 72,300 Hudong 2005 14,000 Trafigura Beheer BV 9 Months

Alpine Penelope LR1 74,400 Sungdong 2008 14,500 Inc Options Vitol 1 Year

Nord Vantage MR2 50,600 Hyundai Vinashin 2018 16,000 Union Maritime 1 Year

Centennial Misumi MR2 47,200 Onomichi Dockyard 2008 13,250 Phillips 66 1 Year

Front Loki Suezmax 156,000 Jiangsu Rongsheng 2010 23,500 Repsol 1 Year Example CSV Vessel Name, Type, DWT, Yard, Built, Rate, Charterer, Period Alpine Persefone, LR1, 74500, Sungdong, 2008, 13500, Navig8, 1 Year Delimiters Vessel Name stops when LR1 or MR2 or Suezmax or VLCC or LR2 or or MR1 or Handy appears. DWT is always a number Yard is always Text Built is always a number Rate is always a number Charterer can be text and numbers Period maybe days, month, months, year, years, min-max Again I prefer a formula over a Macro Many thanks for any help you can provide. Kind regards Bear 1

<colgroup><col></colgroup><tbody>
</tbody>

 

[bear1]

Hi Peter, how are you?

I have another Text to Columns problem i want to solve. It's very similar to the last one but the column layout is different.

I want to split the follow text strings into columns. Below I have written the delimiters:

Alpine Persefone LR1 74,500 Sungdong 2008 13,500 Navig8 1 Year

Archangelos Gabriel LR1 72,300 Hudong 2005 14,000 Trafigura Beheer BV 9 Months

Alpine Penelope LR1 74,400 Sungdong 2008 14,500 Inc Options Vitol 1 Year

Nord Vantage MR2 50,600 Hyundai Vinashin 2018 16,000 Union Maritime 1 Year

Centennial Misumi MR2 47,200 Onomichi Dockyard 2008 13,250 Phillips 66 1 Year

Front Loki Suezmax 156,000 Jiangsu Rongsheng 2010 23,500 Repsol 1 Year Example CSV Vessel Name, Type, DWT, Yard, Built, Rate, Charterer, Period Alpine Persefone, LR1, 74500, Sungdong, 2008, 13500, Navig8, 1 Year Delimiters Vessel Name stops when LR1 or MR2 or Suezmax or VLCC or LR2 or or MR1 or Handy appears. DWT is always a number Yard is always Text Built is always a number Rate is always a number Charterer can be text and numbers Period maybe days, month, months, year, years, min-max Again I prefer a formula over a Macro Many thanks for any help you can provide. Kind regards Bear 1

<tbody>
</tbody>