|
|
#1
08-01-2018, 09:39 AM
|
|||
|
|||
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
08-01-2018, 02:54 PM
|
|||
|
|||
|
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 |
Windows 10 
Office 2016
Linear Mode
