Split based on letters and numbers

You can use LEFT function for letters and SUBSTITUTE for numbers

=LEFT(A1,2)

=SUBSTITUTE(A1,B1,"")

Row\Col	A	B	C
1	FR3592049899	FR	3592049899
2	FR3588043313	FR	3588043313
3	PL015020206821	PL	015020206821
4	PL015062430536	PL	015062430536
5	NL177227327	NL	177227327
6	NL177227327	NL	177227327
7	PL015062430536	PL	015062430536
8	PL015020207602	PL	015020207602
9	DE1015228641	DE	1015228641
10	PL015020206821	PL	015020206821
11	FR2998012662	FR	2998012662
12	PL015062430536	PL	015062430536

If your data will ALWAYS begin with 2 letters followed by numbers
This approach will parse the data into 2 columns, beginning in Col_B
• Select your single column list of values
• Data.Text-to-columns
...Select: Fixed width.............................Click: Next
...Insert a break after the second letter....Click: Next
...Set the destination to a cell in Col_B (example: B1)
...Click: Finish

Is that something you can work with?

Or use this formula for the numbers:
=RIGHT(A1,LEN(A1)-2)

Here's another option without having to use formulas.

If the data is in column A make sure column B is empty to accept the parsed data.

Select the data in question
Goto the Data tab>Text to Columns
Select: Fixed Width>Next
In the Data Preview section click between the 2nd and 3rd characters and a split line will appear
Click Next
Click on General above the numbers column
Select: Text from the Column Data Format area
Click Finish