Suppose you need to change the appearance of the data in your worksheet. For instance, you may want to replace dashes in a text string with periods. For example, if you have a phone number formatted as 235-456-7890 you may want to change it to 235.456.7890. This is very easy to do using the SUBSTITUTE
This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.
Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.
- Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
- Large color screenshots illustrate the instructions so following along is easy!
- Email notification of each new exclusive post for subscribers!
- Exclusive discounts on Office books and other products!