Modify Excel cell and reformat assistance.
I have an excel field with a phone number like this: (605) 333-0071
How do I remove the paraenesis,
…![Office]()
Microsoft Office
Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a nu...
Read more- 79K Content
- 14K Contributors
Expert Spotlight
Finance Analyst
30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.
Leading Experts In
Troubleshooting Question
Troubleshooting Question
Can Excel display the the number of rows?
I see Mansfield has 10 rows, and Oxford has 2 rows.
What Excel formula would calculate and display 10
…
Troubleshooting Question
Excel: I need to Transform the CSV import to reduce the size of the set
The file is a CSV and I imported from a small version of the file, which was 72KB. I imported in
…
Troubleshooting Question
How do I get postage online?
I need to specify the amount of postage, print it on my printer, and be certain it is the correct
…
Troubleshooting Question
MS Teams Bundling Change
Hey, all,
Big changes for MS Teams. Let me know if CoPilot response is incorrect or any other
…
Troubleshooting Question
Update file based on date
I have a file whose location cannot be modified. I have to sync that file across all my computers
…
Troubleshooting Question
Import new CSV file data in to an existing Excel workbook with predefined formats
I have an Excel Worksheet ( cal_cost.xlsx ) with predefined column headers. Some examples of the
…
Troubleshooting Question
vba to create a folder based on a path in the open workbook cell
I want to use vba to create a folder based on a path saved in the
Open workbook,
…
Troubleshooting Question
MS Office 2021 Offline Update Solution
Hello,
I'm managing a Zone-C network with no access to any external networks including the Internet.
…
Troubleshooting Question
Intune or Another RMM program
Have a client with about 70 users, about 60 are users using their own personal laptops or computers.
…
Troubleshooting Question
SharePoint Issue with Excel sheet with hyperlinks
Hello,
We have an Excel spreadsheet within a SharePoint folder that for whatever reason the
…
Advice Question
How to format Microsoft Forms Excel responses for time sheets
We want to implement a new time sheet solution for our employees. We are used to them sending us
…
Troubleshooting Question
Moving rows by value
Hello,
I got the following from youtube and added to it to meet my needs (just added a little bit.)
…
Advice Question
Excel Data Model - Equivalent of vlookup in worksheet table to cross-ref Data Model Table
I have a table in the data model (loaded from a query) with only 2 columns: (1) ID, which is a text
…
Troubleshooting Question
Highlight Closest Value based on another cell value.
I have a number in cell M14 and a table with a range of a3-j3 (this includes headers) that can
…
Troubleshooting Question
EXcel first in first out 12 month expiration time
Column a is the month, Column b is the monthly Generation credits and Column c is the month amount
…
Troubleshooting Question
Outlook 365 is not showing me shared calendar reminder notifications
Outlook 365 will display notifications on my local calendar, but not from a shared calendar (which I
…
Troubleshooting Question
Converting Cells with Excel formula into Power Query
Hello,
I'm new to Power Query. I'm working on a project where I still need to convert formulas I
…
Troubleshooting Question
Networking over the WWW
Hello I have a project where I want some requests to server outside the office,. but want to develop
…
Troubleshooting Question
macros not digitally signed in excel 2003
A customer of mine, running windows 7 with microsoft excel 2003 had me change his hard drive to a
…Explore solutions and more
![Office]()
Microsoft OfficeBack to the top
Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.