Quote:
Originally Posted by xor
Your example is very limited.
Please give more examples of what can appear in columns B and C. I guess other things than blank - why else concatenate? And don't forget to mention what should appear in column A.
|
In cells B and C are only numbers (accessed by Vlookup) in format 0,00000 or blank, i concatenate because number will contain only one cell. A1 should display only that one number.