Question
To the left of column G, insert a new table column. Use the SUBSTITUTE function to remove the text string 1- from values in the
To the left of column G, insert a new table column. Use the SUBSTITUTE function to remove the text string "1-" from values in the Phone column, replacing that text string with an empty text string. Copy and paste the formula values into the Column1 column, delete the Phone column, and then rename the Column1 field as Phone.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Managing Hospitality Human Resources
Authors: Robert H Woods, Educational Institute Staff American Hotel & Lodging Association
4th Edition
0866122877, 9780866122870
