How to separate decimal number and text

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to separate decimal number and text

08-01-2018, 02:54 PM

jeffreybrown jeffreybrown is offline

Windows Vista How to separate decimal number and text

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 PM.