Ignore #N/A in concatenate formula

[RPlain]

I have a Vlookup that takes a vehicle registration and looks up the drivers name. The information is pulled in in two columns - First name and Last Name. I then have a third column where i have a concatenate formula to bring the name into one cell. If the registration is not found I get an #N/A which is expected. How can I get the third column to ignore the #N/A? The reason being, I want to count the instances of each name in the worksheet and don't want thousands of #N/As to be counted as well as it messes with my figures. Any help is appreciated.

 

[Aladin Akyurek]

=COUNTIFS(range,"?*")

will ignore #N/A's in range.

 

[RPlain]

Thanks Aladin, perfect!