View Single Post
 
Old 08-01-2018, 09:39 AM
banguyen banguyen is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2018
Posts: 1
banguyen is on a distinguished road
Default How to separate decimal number and text

Hello,

I was wondering if I could get help with separating data into text and decimal number. The received data are in this format .25I, .510H, and 1.23L, and I want to separate them into .25, .510, 1.23, I, H, and L. I have tried following (https://www.extendoffice.com/documen...d-numbers.html) to write a module for it but I got 25, 510, 123, .I, .H, and .L.

Thanks in advance!
Reply With Quote