Concatenate Cell Range With Blanks

[ststern45]

Hello,

Looking for a formula that will Concatenate a range of cell values that will keep the values intact.
For example,
Cells:
A1 = 0000
A2 = 777
A3 = 333
A4 = 222
A5 = 99
A6 = 88
A7 = 9
A8 = 8
A9:A20 are blank but could contain values.

Concatenate Cells A1:A20
B1 = 0000, 777, 333, 222, 99, 88, 9, 8

Thank you

 

[ststern45]

OK thanks. I will look into the Trust Center.

 

[ststern45]

I tried tinkering with some settings but the Function will not calculate the formula in other worksheets where the function formula is used.

 

[JoeMo]

Is your calculation on Manual or Automatic? If Automatic, try adding this line right below the Function(...) line:

Application.Volatile

If on Manual, press the F9 key to trigger calculation or set Calculation to Automatic.

 

[ststern45]

Thanks Joe. Will give it a try.