I have a column of cells that have "USD " then a dollar amount. How can I have a column right next to it that will only have the number? The number is in the form "123.45" or if it is a credit it is "(60.00)".
I want the USD and space after deleted. Thanks!