Excel Formula help

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Formula help

FAQ

Thread Tools

Display Modes

05-02-2016, 11:50 PM

xor

Windows 10 Excel Formula help

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

If you have your \$20000 in column A you could try (in a helper column):

=SUBSTITUTE(SUBSTITUTE(A1;"\$";"");CHAR(160);"")*1

and copy downwards as far as needed and use your own formula on that helper column.

If that doesn't help maybe you could attach a workbook with some representative data.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel formula help please!	dreamer1963	Excel	2	03-16-2014 03:59 AM
Help with excel formula	GoldenSlumbers	Excel	2	12-13-2012 03:32 AM
** Excel Formula	djreyrey	Excel	8	04-15-2011 03:55 PM
Excel Formula Help	masoom84	Excel	1	03-07-2009 09:41 AM
Excel Formula Help	Shahzad	Excel	1	12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 PM.