ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 950
- Office Version
- 365
- 2010
- Platform
- Windows
Good day everyone,
I have a question about how to concatenate a range of cells.
1>Each cell can have a value 1 through 49
2>If a cell has a value between 1 and 9 I would like to concatenate the cell with a space after the value.
3>Total of 6 cells that contain a value. Cell columns A1 through F1.
Example 1,
Cell A1 = 1
Cell B1 = 2
Cell C1 = 3
Cell D1 = 4
Cell E1 = 5
Cell F1 = 6
If I concatenate the cell range A1 through F1 in cell G1 I want it to look like this (with a space after each value)
1 2 3 4 5 6
Example 2,
Cell A1 = 1
Cell B1 = 2
Cell C1 = 3
Cell D1 = 15
Cell E1 = 24
Cell F1 = 49
If I concatenate the cell range A1 through F1 in cell G1 I want it to look like this (with a space after each value)
1 2 3 152449
Thanks in advance!!
I have a question about how to concatenate a range of cells.
1>Each cell can have a value 1 through 49
2>If a cell has a value between 1 and 9 I would like to concatenate the cell with a space after the value.
3>Total of 6 cells that contain a value. Cell columns A1 through F1.
Example 1,
Cell A1 = 1
Cell B1 = 2
Cell C1 = 3
Cell D1 = 4
Cell E1 = 5
Cell F1 = 6
If I concatenate the cell range A1 through F1 in cell G1 I want it to look like this (with a space after each value)
1 2 3 4 5 6
Example 2,
Cell A1 = 1
Cell B1 = 2
Cell C1 = 3
Cell D1 = 15
Cell E1 = 24
Cell F1 = 49
If I concatenate the cell range A1 through F1 in cell G1 I want it to look like this (with a space after each value)
1 2 3 152449
Thanks in advance!!