In column T there are numbers with an R at the beginning eg R 70.00
The number of spaces between the R and the number may vary
I need a bit of code that will replace all of the spaces and R's with nothing, and if it did contain an R the number needs to be turned negative.
Thanks in advance!
The number of spaces between the R and the number may vary
I need a bit of code that will replace all of the spaces and R's with nothing, and if it did contain an R the number needs to be turned negative.
Thanks in advance!