plz solve exercise 6 and show excel formula now

Column B contains the salary gathered from the online survey. By default, the currency is USD (and in that case, it is not shown with the amount). However, for any other currency, it is added to the cell (like for example: 5000 EUR, and the cell is now considered as text). To analyze the gathered data, all the salaries should be first transformed into USD. To do so: 4. Insert in column C the corresponding function to extract the amount only from column B. Hint: Search for a space in the Salary as Text. If there is a space, use the left function to extract the amount. If there is no space, take the full cell content. To check if there is a space, you can use the find function. If the function returns an error, it means there is no space. 5. In column D, extract the currency from column B. (One way to do it: compare the cell in column B to that in column C. If they are the same, so the currency is USD. If they are different, use the right function to take the last 3 characters). 6. You have the salary amount and the salary currency, now you can convert all the salaries into USD. Using the conversion table shown at the top of the sheet, insert in column E the needed IFS function to convert the salary amount into USD. 7. Do the same in column F but this time using the function SWITCH