Explore Office on Experts Exchange

Expert Solutions for Your Tech Problems

OfficeMicrosoft 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.

Troubleshooting Solution

Assign a pay period based on a date range

byTom M
1

Book1.xlsxI am looking for a formula to put into column B that would assign the corresponding pay

Troubleshooting Solution

Extract text from an Excel cell.

1

Hello, 


I have an excel field like this: 0070 - Station1


What is the formula to use to remove all

Troubleshooting Solution

Remove everything after a character in a Excel field.

6

Hello, 


I have a column in Excel which looks like the below. 

Destination (Display Name)

"Tom Salas

Troubleshooting Solution

How do I  import this data into Excel?

9

I have text files using the pipe symbol as a delimiter, and need to import them into Excel.


Here is

Troubleshooting Solution

Excel 365 allows overlapping areas in a scattered Selection. Why?

1

At one time Excel 2016  prevented overlapping cells in a scattered selection.

Excel 365 no longer

Troubleshooting Solution

index match formula excel

1

Hi, i need some match index formula for a sheet im working on, i need to map the mapped name column

Troubleshooting Solution

how to extract the email names from the distribution list from the Outlook address book in Excel spreadsheet as a column

2

how to extract the email names from the distribution list from the Outlook address book in Excel

Troubleshooting Solution

How do I Save, Edit and Send a Word Document on my iPhone

14

I see how to Save the file. I have saved it to Documents.


How do I open that file so I can change its

Troubleshooting Solution

If statement using dates.

byTom M
2

Book2.xlsxPlease see cell n2, I am not sure what is wrong with this I think it has to do with the

Troubleshooting Solution

MS Office 2021 Offline Update Solution

2

Hello,

 I'm managing a Zone-C network with no access to any external networks including the Internet.

Troubleshooting Solution

Count Unique Excel Values by Using the SUM and COUNTIF Functions

1

Hello, 

my existing formula needs to be modified. It works as long as I don't apply filters on my

Troubleshooting Solution

Hours and minute formula between two cells

byTom M
1

Hours and minute formula between two cells, I need to get a formula that will give me the hours and

Troubleshooting Solution

Need an Excel formula (not array) to return a value if a word in one cell matches another.

8

Book1.xlsx


I have a list of words in Cells B1:B5. I want to return the value "Yes" if any of these

Troubleshooting Solution

Error with linked Excel file on date field.

bybfuchs
13

Hi Experts,

Why do I get in one pc an error when linking to an excel file and field defined as

Troubleshooting Solution

Change font size of one part of an excel cell

byJose C
2

i have the following formula in a column in excel


=row()&" D1 RI "&TEXT(COUNTA(A$2:A2)+1,"00000")


how

Troubleshooting Solution

Macro code problem

9

Hi,

It is having the error

to the line like

Worksheets(List1).Cells(RowID2, 8).Value = Format(Now -

Advice Solution

How to format Microsoft Forms Excel responses for time sheets

4

We want to implement a new time sheet solution for our employees. We are used to them sending us

Troubleshooting Solution

Convert entire column to number

bybfuchs
16

Hi Experts,

How do I convert the entire column to numbers, when trying to drag down the right corner,

Troubleshooting Solution

SharePoint 2019  - Replacing Lists with Imports

byJake S
2

I have a form in SharePoint 2019 (local server)  that does a lookup from a list called "Assignment"

Troubleshooting Solution

How do I rotate the direction of a PDF document?

5

I have a front and a back of a PDF with legal-sized document, but it has both sides stacked

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more