Text to columns not function not worked for a cell

[hunghung]

I have a cell with data combined together with semicolon ";" as cell A1. However, when I use text to columns function with delimited semicolon, it only appear two columns B1 and C1 with results as below.
Please help me this case.
Thanks,

Book1
	A	B	C
1	12600215;Delivery Date Hemp Blend T-shirt M;2024-11-08 113 Chalk White;S;30;7323451002397;	12600215	Delivery Date
Sheet1

 

[Fuji]

Not familiar with RegExp or vba?

 

[hunghung]

I know a little about VBA but not much.

 

[Fuji]

If you want non vba solution, sorry but I can't help you in this case.

 

[hunghung]

Thank you for your VBA solution Fuji. I apreciate this.
I just rechecked Alex's comment and found function Textsplit that Alex suggest. Tried and it worked for me with delimiter double spaces " "

=TEXTSPLIT(A1," ",,TRUE,1)

 

[Alex Blakenburg]

It sounds like you have something that works for you now. Let us know if that is not the case. Glad we could help.