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:

[TABLE="width: 572"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Alpine Persefone LR1 74,500 Sungdong 2008 13,500 Navig8 1 Year[/TD]
[/TR]
[TR]
[TD]Archangelos Gabriel LR1 72,300 Hudong 2005 14,000 Trafigura Beheer BV 9 Months[/TD]
[/TR]
[TR]
[TD]Alpine Penelope LR1 74,400 Sungdong 2008 14,500 Inc Options Vitol 1 Year[/TD]
[/TR]
[TR]
[TD]Nord Vantage MR2 50,600 Hyundai Vinashin 2018 16,000 Union Maritime 1 Year[/TD]
[/TR]
[TR]
[TD]Centennial Misumi MR2 47,200 Onomichi Dockyard 2008 13,250 Phillips 66 1 Year[/TD]
[/TR]
[TR]
[TD]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

[/TD]
[/TR]
</tbody>[/TABLE]

 

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

[TABLE="class: cms_table, width: 572"]
<tbody>[TR]
[TD]Alpine Persefone LR1 74,500 Sungdong 2008 13,500 Navig8 1 Year[/TD]
[/TR]
[TR]
[TD]Archangelos Gabriel LR1 72,300 Hudong 2005 14,000 Trafigura Beheer BV 9 Months[/TD]
[/TR]
[TR]
[TD]Alpine Penelope LR1 74,400 Sungdong 2008 14,500 Inc Options Vitol 1 Year[/TD]
[/TR]
[TR]
[TD]Nord Vantage MR2 50,600 Hyundai Vinashin 2018 16,000 Union Maritime 1 Year[/TD]
[/TR]
[TR]
[TD]Centennial Misumi MR2 47,200 Onomichi Dockyard 2008 13,250 Phillips 66 1 Year[/TD]
[/TR]
[TR]
[TD]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[/TD]
[/TR]
</tbody>[/TABLE]