excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
for example
and just for future goggling, how should i needed to search for it? cause when i google it all i found was merging the values/text in two cells into one, like a1=bob and b1=evans so c1=bob evans
for example
test | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | wanted result | |||||
2 | 1 | 10 | 1 | |||
3 | 2 | 11 | 2 | |||
4 | 3 | 12 | 3 | |||
5 | 4 | 13 | 4 | |||
6 | 5 | 14 | 5 | |||
7 | 6 | 15 | 6 | |||
8 | 7 | 16 | 7 | |||
9 | 8 | 17 | 8 | |||
10 | 9 | 18 | 9 | |||
11 | 10 | |||||
12 | 11 | |||||
13 | 12 | |||||
14 | 13 | |||||
15 | 14 | |||||
16 | 15 | |||||
17 | 16 | |||||
18 | 17 | |||||
19 | 18 | |||||
test |
and just for future goggling, how should i needed to search for it? cause when i google it all i found was merging the values/text in two cells into one, like a1=bob and b1=evans so c1=bob evans