Need help separating data please

[Sivory18]

Hi , as you can see via the screenshot, I want to separate the number from the letters. For example 0.00000N, I want column A to be: 0.00000 and column B to be: N. but the problem is that the lengths aren't all the same, so some data will have 9 characters in total and other will have like 8,10 or even 11.

[alexnajm]

Use a Formula the create your two new columns - the first to get the last character with a RIGHT function and the second to REPLACE the output of the first formula with nothing!

[alexnajm]

Also these should be posted in Designer Desktop for future reference!

[Sivory18]

What formula do i use for the REPLACE

[alexnajm]

The replace formula… Replace([3], [formula one output], “”)

[Yash9889]

Using the Regex Tool, you can split the column into two. Below is a sample flow demonstrating how to use the Regex Tool for parsing the two columns.The Regular Expression used is :^([\d\.]+)([A-Z])$.
Hope this might Help.