I am trying to add text using the concatenate function....for example=concatenate(a2,b2,c2) which works fine however if I try this =concatenate(a2:c2) comes back with a hashVALUE error....but......
What I am trying to achieve is to extract data from a report which gives me the subject the student is studying, import into excel.... and then in cell (A2) I could have Art and in the next two cells (B2&C2) it is blank and the fourth cell (D2) could have Biology and the next cell blank (E2)...followed by History (F2)
What I would like to see is Art; Biology; History in one cell.
Any help would be much appreciated.
Thanks in advance.
<tbody>
</tbody>
What I am trying to achieve is to extract data from a report which gives me the subject the student is studying, import into excel.... and then in cell (A2) I could have Art and in the next two cells (B2&C2) it is blank and the fourth cell (D2) could have Biology and the next cell blank (E2)...followed by History (F2)
What I would like to see is Art; Biology; History in one cell.
Any help would be much appreciated.
Thanks in advance.
Art | Biology | History | Art; Biology; History | |||
Chem | RE | PE | Chem; RE; PE | |||
Art | RE | History | Art; RE; History | |||
<tbody>
</tbody>
Last edited: