Question: EXCEL QUESTION - - using the TEXT function, how would i take the phone number from column K and format the phone number to be

EXCEL QUESTION -- using the TEXT function, how would i take the phone number from column K and format the phone number to be "XXX-XXXX" for numbers with no area code, and "(XXX)XXX-XXXX" for numbers with an area code? thank you.
EXCEL QUESTION -- using the TEXT function, how would i take

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

I need to Create and integrate a script on the registration.html page that stores the input field data into hidden fields to be used in the interests.html page once the submit button is pressed....

Q:

Gift Card Emporium, the medium - sized e - tailer where you work, is interested in learning more about their gift card sales. Your manager has asked you to work with a subset of the sales data to see...

Q:

I need help with Query Strings and Storing Persistent Information I need help to Modify the "registration.html" page below to send a query (that has all input field information from that form) to a...

Q:

I need help with Query Strings and Storing Persistent Information I need help to Modify the "registration.html" page below to send a query (that has all input field information from that form) to a...

Q:

I having a hard time completing this excel project Guided Project 6-2 In a workbook for Eller Software Services, you calculate deviation statistics for sales by product and city. You verify phone...

Q:

Taxpayer Information Taxpayer name: Taxpayer SSN: Taxpayer DOB: Taxpayer occupation: Bruce H. Harrison 201-00-0045 April 1, 1977 Contractor Spouse name: Spouse SSN: Spouse DOB: Spouse occupation:...

Q:

Your manager looked at your new phone format and decided that they want it a little different. In the ActualPhone column, use the TEXT function to take the data from the Phone column and format it ....

Q:

Bus299: Excel To be answered using appropriate Excel functions and/or formulas. There is no partial credit for incorrect usage. Use appropriate formatting of cells where needed. Save frequently. Keep...

Q:

Bus299: Excel To be answered using appropriate Excel functions and/or formulas. There is no partial credit for incorrect usage. Use appropriate formatting of cells where needed. Save frequently. Keep...

Q:

Bus299: Excel- SHOW THE FORMULAS!!!!!! To be answered using appropriate Excel functions and/or formulas. There is no partial credit for incorrect usage. Use appropriate formatting of cells where...

Q:

Kipande Ltd. is a Kenyan incorporated company. The following statement of comprehensive income of the company for the year of income 2019 Sh. 000 Sh. 000 Gross profit 59,000 Less: Depreciation 4,872...

Q:

McDonalds Corporation has reported the following values for total revenues and net income during the 1998 to 2005 period. All data are in billions of dollars: Determine the least-squares regression...

Q:

Trends in retirement have changed over the years with more people working past traditional retirement age. Which on the following is a reason for these changes in recent decades? A ) The mandatory...

Q:

Please with clear explanation 10. Case study: Kings Fruit Farm In the 1920s Edward Filbert became the tenant of Kings Farm in Cambridgeshire. In 1978 his grandson James Filbert became the latest...