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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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,655
Messages
5,549,261
Members
410,905
Latest member
Extjel
Top