Excel formula to subtract cells while ingnoring text

**sunboy** · 09-15-2024, 01:00 PM

Hi

I'm kindly asking for Excel Formula to subtract or add cells from one and other whilst ignoring text as shown on the desired solution.

Thank you.

**Fluff13** · 09-15-2024, 01:06 PM

How about

Formula:

=TEXTAFTER(B5,"-")-TEXTAFTER(C5,"-")

**sunboy** · 09-15-2024, 01:40 PM

Hi

Thank you for the great formula

**Fluff13** · 09-15-2024, 01:42 PM

You're welcome & thanks for the feedback.

Excel formula to subtract cells while ingnoring text

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Excel formula to subtract cells while ingnoring text

Re: Excel formula to subtract cells while ingnoring text

Re: Excel formula to subtract cells while ingnoring text

Re: Excel formula to subtract cells while ingnoring text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Subtract from previous non-empty cells with blank cells and text

[SOLVED] VBA to count number of populated cells within a specified range ingnoring forulas.

[SOLVED] Cell subtract cells with specific text formula needed please

Sumifs formula with ingnoring the duplicates dates or shifts or so on

Ingnoring #n/a in a cell with a lookup formula?

Subtract data (text) from cells from A2

[SOLVED] Earliest Date, ingnoring text #N/A

Bookmarks

Bookmarks

Posting Permissions