excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
i need to return the values of range
1-2-3-4-5-6
and also
4-5-6-7-8-9
but instead going with two cells, is there a way to put them together?
like
and of course this isn't working
so it'll return
1-2-3-4-5-6-7-8-9
i need to return the values of range
Excel Formula:
=c3:h3
and also
Excel Formula:
=c5:h5
but instead going with two cells, is there a way to put them together?
like
Excel Formula:
=c3:h3,c5:h5
so it'll return
1-2-3-4-5-6-7-8-9