User Justin Doward

3 votes

Left trim: Remove characters after last instance of a number

answered May 7, 2020 at 16:34

2 votes

Split text at last instance of character (retain left hand side)

answered May 1, 2020 at 1:55

2 votes

multiply quantity by time - how do you calculate 15 times 30mins?

answered May 27, 2020 at 8:20

2 votes

Accepted

In Excel sheet I want to add semicolon to a cell that time format is HH MM SS

answered May 30, 2020 at 10:36

2 votes

IFS function in excel not able to work

answered Jun 1, 2020 at 10:36

2 votes

Ms Excel copy and paste data duplicate by x

answered Mar 26, 2020 at 7:58

2 votes

Specific cell to always have the same formatting, ignoring if new rows are created above

answered Mar 31, 2020 at 3:19

2 votes

How to define default program to open splitted xxx#. files and convert them to txt format

answered Apr 18, 2020 at 4:47

2 votes

Excel - Visual Basic issue

answered Apr 23, 2020 at 2:32

2 votes

How to create a column in Excel that tracks when data was input in a neighboring cell?

answered Jun 8, 2021 at 8:29

1 vote

Can I change the default match method in Excel from "Less than" to "Exact match"?

answered Apr 15, 2020 at 13:07

1 vote

Accepted

How to check duplicates value in columns

answered May 31, 2021 at 13:24

1 vote

Accepted

How to fill cells in the Excel with serie, range or similar?

answered Jan 16, 2021 at 2:57

1 vote

Accepted

Finding similar strings within two cells in excel

answered Sep 4, 2021 at 8:38

1 vote

What Excel function constructs and returns a reference to a range of cells?

answered Jul 9, 2020 at 4:35

1 vote

ExcelVB Programming Application

answered Aug 12, 2020 at 5:15

1 vote

Accepted

if function don't checks else if statement

answered Aug 26, 2020 at 7:38

1 vote

Accepted

How to conditionally concatenate a range with VBA?

answered Aug 26, 2020 at 16:07

1 vote

Accepted

showing error when use loop in vba

answered Aug 27, 2020 at 5:01

1 vote

Accepted

Excel: different number of digits in the same column Excel

answered Sep 9, 2020 at 15:09

1 vote

Accepted

Append & Remove values from multiple cells, convert resultant cell into Column

answered Sep 9, 2020 at 16:06

1 vote

Accepted

Excel bearing calculations

answered Apr 24, 2020 at 3:33

1 vote

Accepted

Compare two lists, for every match return value from adjacent column

answered Apr 24, 2020 at 10:00

1 vote

Display column header containing highest value in a spreadsheet

answered Apr 13, 2020 at 7:44

1 vote

Excel Macro - Hide and Unhide based on cell value

answered Mar 26, 2020 at 8:19

1 vote

Excel formula issue for entering "0" with empty cells

answered Mar 26, 2020 at 8:26

1 vote

I need to use an excel formula that takes a keyword in one column in order to extract full name of another column

answered Jun 11, 2020 at 7:19

1 vote

Accepted

Macro or VBA to select first empty cell in a column invoked from a pop up with 3 options, Macro 1, Macro 2 or cancel

answered Jun 13, 2020 at 8:13

1 vote

Accepted

Adapt existing VBA macro code to clear column, adjust row height and autofit column

answered Jun 13, 2020 at 22:28

1 vote

Accepted

Working with Excel 2016 and the length of an audio file eg, 0.004293981 = 0:06:11 (h:mm:ss)

answered Jun 26, 2020 at 3:41

Stack Exchange Network

81 Answers

Left trim: Remove characters after last instance of a number

Split text at last instance of character (retain left hand side)

multiply quantity by time - how do you calculate 15 times 30mins?

In Excel sheet I want to add semicolon to a cell that time format is HH MM SS

IFS function in excel not able to work

Ms Excel copy and paste data duplicate by x

Specific cell to always have the same formatting, ignoring if new rows are created above

How to define default program to open splitted xxx#. files and convert them to txt format

Excel - Visual Basic issue

How to create a column in Excel that tracks when data was input in a neighboring cell?

Can I change the default match method in Excel from "Less than" to "Exact match"?

How to check duplicates value in columns

How to fill cells in the Excel with serie, range or similar?

Finding similar strings within two cells in excel

What Excel function constructs and returns a reference to a range of cells?

ExcelVB Programming Application

if function don't checks else if statement

How to conditionally concatenate a range with VBA?

showing error when use loop in vba

Excel: different number of digits in the same column Excel

Append & Remove values from multiple cells, convert resultant cell into Column

Excel bearing calculations

Compare two lists, for every match return value from adjacent column

Display column header containing highest value in a spreadsheet

Excel Macro - Hide and Unhide based on cell value

Excel formula issue for entering "0" with empty cells

I need to use an excel formula that takes a keyword in one column in order to extract full name of another column

Macro or VBA to select first empty cell in a column invoked from a pop up with 3 options, Macro 1, Macro 2 or cancel

Adapt existing VBA macro code to clear column, adjust row height and autofit column

Working with Excel 2016 and the length of an audio file eg, 0.004293981 = 0:06:11 (h:mm:ss)