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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:51 AM.