M
marti
I have a row of cells with data that needs to be combined into one cell and
be seperated by a semicolon and a space.
Example:
a
b
c
d
e
I want it to read like this: a; b; c; d; e; in 1 cell.
I have been trying to use a text srting like this :
=A1&"; "&A2&A3&"; "&A4...etc
The problem I am running into is that this works fine for a small # of
cells, but I have much larger #s of cells that I need to combine this way and
it will take a long time to type them all in.
Any ideas?
Thanks!
Marti
be seperated by a semicolon and a space.
Example:
a
b
c
d
e
I want it to read like this: a; b; c; d; e; in 1 cell.
I have been trying to use a text srting like this :
=A1&"; "&A2&A3&"; "&A4...etc
The problem I am running into is that this works fine for a small # of
cells, but I have much larger #s of cells that I need to combine this way and
it will take a long time to type them all in.
Any ideas?
Thanks!
Marti