1、 Extract
one

 =IFERROR (MID (A1, FIND ("-", A1, FIND ("-", A1)+1)+1, LEN (A1) - FIND ("-", A1, FIND ("-", A1)+1)), "") first line =The second line of IFERROR (MID (A2, FIND ("-", A2, FIND ("-", A2)+1)+1, LEN (A2) - FIND ("-", A2, FIND ("-", A2)+1), "") example: 1-5-999 1-22-9999 1-333-99999 Extract from nine hundred and ninety-nine nine thousand nine hundred and ninety-nine

Example

two

34-03-E6-A8-1B-3C (192.168.1.15), 34-03-E6-A8-1B-3C extracted from 04-0E-3C

Use formula:

 =LEFT(A1, FIND("(", A1) - 1)

2、 Calculation
one

 Open an Excel file. Press ALT+F11 to open the VBA editor. In the VBA editor, insert a new module. Copy and paste the following code into the new module. Function SumColoredCells(rng As Range) As Double Dim cell As Range Dim total As Double total = 0 For Each cell In rng If cell. Interior. Color<>RGB (255, 255, 255) Then 'is modified to the color you want. Here we use white as an example total = total + cell. Value End If Next cell SumColoredCells = total End Function Use: (calculate A1: H1) area colored values =SumColoredCells(A1:H1)

Example

Copyright: Eric Qiu*

Link to this article: https://eblog.ink/archives/352/

The source and this statement shall be indicated when reprinting