#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
How about...
With your data in A1:A3 B1 copied down >>=RIGHT(A1) C1 copied down >> =SUBSTITUTE(A1,B1,"")+0 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Include multiple (but varying in number) Excel rows in each separate email | mrjimi | Mail Merge | 3 | 12-10-2017 09:45 AM |
how to separate number in excel | yoyo4 | Excel | 1 | 11-21-2017 09:46 AM |
How to create a decimal point after each number in a numbered list in excel | wondermuse | Excel | 1 | 03-06-2017 03:42 AM |
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal | jadess916 | Excel | 1 | 06-26-2014 03:48 AM |
Mail Merge, Number to 2 Decimal Places | Vampy99 | Mail Merge | 7 | 09-25-2011 05:41 AM |