Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Rob Henson
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.

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

bynav2567
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?

bycuriouswebster
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?

byRobert Berke
1

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

Excel 365 no longer

…
Troubleshooting Solution

index match formula excel

bySeamus2626
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

byRoman F
2

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

…
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

Count Unique Excel Values by Using the SUM and COUNTIF Functions

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

byCactus1993
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

byPeter Chan
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

byIP4IT Staff
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

Rxcrl hours minute formula to days

byTom M
2

Please see the attached what formula would give me the .23 in the exampleBook1.xlsx

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

Format column as a link

bybfuchs
9

Hi Experts,

How do I set a column in Excel containing URL's to act as a link?

See below, this is just

…
Troubleshooting Solution

Move old excel data to another sheet

bymilitary donut
12

Hello,  

I was hoping someone can help me with the code for a macro to do the below:


I have an excel

…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more