After VLOOKUP runs, we have:

and TEXTJOIN returns the string “946”.

The math operation will coerce the string into a number.

For example, =MID(“apple”,2,3) returns “ppl”.

Excel formula: Abbreviate names or words

ROW Function

The Excel ROW function returns the row number for a reference.

For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.

When no reference is provided, ROW returns the row number of the cell which contains the formula.

Excel formula: Clean and reformat telephone numbers

you might use the T function to remove values that are not text.

Excel formula: Create array of numbers

Excel formula: Strip non-numeric characters

Excel formula: Strip html from text or numbers

Excel formula: Strip numeric characters from cell

Excel formula: Sum text values like numbers

Excel TEXTJOIN function

Excel VLOOKUP function

Excel MID function

Excel ROW function

Excel T function