marcusmark
Board Regular
- Joined
- Nov 17, 2014
- Messages
- 98
Hi,
Is there a vba code to concatenate range of cells?
The range will start with CellA1 and can have up CellA1000 but this is not definite as it can be lower than that.
Concatenation need ";" as its separator.
Sample is when I have Apple in CellA1, Mango in CellA2, Orange in CellA3....the value in CellC1 will be Apple;Mango;Orange
Thanks!
Is there a vba code to concatenate range of cells?
The range will start with CellA1 and can have up CellA1000 but this is not definite as it can be lower than that.
Concatenation need ";" as its separator.
Sample is when I have Apple in CellA1, Mango in CellA2, Orange in CellA3....the value in CellC1 will be Apple;Mango;Orange
Thanks!