EXCEL HELP
assignment 8
Write an Excel formula to convert a 1-800 phone number to digits. Initially when the workbook is opened, the user sees:
The user then enters 4 upper case characters in D3. The digits for the phone number are shown in D5:
Do not display the number until all 4 characters are entered:
Extra worksheets are allowed.