Microsoft Office Forums - View Single Post - How to separate decimal number and text

Thread: How to separate decimal number and text

View Single Post

Old

08-01-2018, 02:54 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

How about...

With your data in A1:A3

B1 copied down >>=RIGHT(A1)
C1 copied down >> =SUBSTITUTE(A1,B1,"")+0

Reply With Quote