Concatenate

[sburkhar]

I'm using the concatenate funtion successfully, however, the cells that are not being used are returning "N/A. Is there a way to have the unused cells remain blank? This sheet populates another sheet and it's going to be time consuming to go thru and remove all of them. I'm trying to take steps out of the process, and I seem to add one step for every 2 I take out.

 

[sburkhar]

I DID that and it didn't work for me! why is it working NOW?!?
oh well, that's why you're answering the questions and not me.
Thank you!