Hi there!

I understand that you are having trouble concatenating cells that contain the #N/A error. This can be frustrating, but there is a workaround that you can use to achieve your desired result.

One way to do this is by using the IFERROR function in your concatenate formula. The IFERROR function allows you to specify a value to be returned if a formula results in an error. In this case, you can use it to return an empty string ("") if the cell contains the #N/A error.

Here's an example formula:

1. =CONCATENATE(IFERROR(A1,""),IFERROR(B1,""),IFERROR (C1,""))

In this formula, A1, B1, and C1 are the cells that you want to concatenate. The IFERROR function is used to check each cell for the #N/A error. If the cell contains the #N/A error, an empty string is returned instead. The CONCATENATE function then combines the values of the cells that do not contain the #N/A error.