formula to split merged text and numbers to their respective column

I have 2 worksheet data 1 , data 2.

In data 1 sheet i have column A with a merge description .

I have to split it in 2 separate colums in column B and C .

So far I have in column B use left formula as it is always 11 digits but need a formula to split description in bold , the list is of 15000 rows

Can anyone assist for formula in bold

10000195955BOITE LUMINEUSE A MESSAGE A4

2 issue

data 2 sheet columns A &B has merge description need to split to their respective in column C and D

Part 1 try in C2 and copy down;

Formula:

Please Login or Register  to view this content.

thanks for formula . works

any idea with 6 slovenie on data 2 sheet

Originally Posted by JEAN1972

any idea with 6 slovenie on data 2 sheet

Do you have more sample data? Say 50 rows?

Hi,

For your question regarding data2 sheet, try these:

In C2 copied down:

Formula:

Please Login or Register  to view this content.

In D2 copied down:

Formula:

Please Login or Register  to view this content.

See attached.

Thank you all for assistance for solution provided

You're welcome, thanks for the feedback.