Excel TEXTJOIN Function

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) For example = TEXTJOIN(” […]

Excel VBA Delete all #N/A

VBA code to delete all #N/A error in Excel #N/A error can occur as a return code from any Excel formula like Vlookup, Lookup etc., If you copy paste data only from a worksheet that has formula, then this #N/A error will occur as a string value. You can remove […]