excel concatenate not working code example

Example: excel concatenate not working

If the formula is showing, ensure that the column is Not formatted to "Text".
If it is Text, delete the formula, format as "General", and re-type the formula.