Concatenate Cell Range With Blanks

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
798
Office Version
  1. 2010
Platform
  1. Windows
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

Well-known Member
Joined
Sep 17, 2005
Messages
798
Office Version
  1. 2010
Platform
  1. Windows
OK thanks. I will look into the Trust Center.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
798
Office Version
  1. 2010
Platform
  1. Windows
I tried tinkering with some settings but the Function will not calculate the formula in other worksheets where the function formula is used.
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,326
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,607
Messages
5,548,958
Members
410,885
Latest member
I Hate Computers
Top