gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 696
- Office Version
- 2019
- Platform
- Windows
Hello,
How can I concatenate a column BEFORE a cell that contains a certain value in column (D12=?????)?
Only D3:D11 should be concatenated. All cells in D3:D17 contain a Formula.
thank you
How can I concatenate a column BEFORE a cell that contains a certain value in column (D12=?????)?
Only D3:D11 should be concatenated. All cells in D3:D17 contain a Formula.
thank you
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3:D17 | D3 | =MID($A3,FIND("""",$A3)+1,FIND("""",$A3,FIND("""",$A3)+1)-FIND("""",$A3)-1) |