Excel Fundamentals for Data Analysis | Online Course Support

In column F we need to get the payment amount from the BPAY sheet, but you will notice it is being treated as text because of the “AU” at the front. Apply functions to remove the unwanted characters and convert to a number. Which of the following combinations of calculations could you use?

 
 
 
 

Similar Posts