I need to create a formula which will allow me to substitute/delete text that
appear in numbers. ie HKD-2,500.00 or YEN-2,500.00. I have used the
substitute formula but it will only delete one of the text's specified but I
want it to pick one or the other
ie HKD/YEN. Can the substitute formula be nested if so how?