G
Guest
Good afternoon. I know you can either use the concatenate function or the
formula =A1&B1 to combine cell contents.
However, if I am combining contents from 100 different cells, individually
selecting the cells become more cumbersome.
Is there a way to short cut this formula to pick up a range of cells I need
to combine the contents for?-- kind of how the reverse function of it works
for Text to Columns?
Thank you very much,
Storm
formula =A1&B1 to combine cell contents.
However, if I am combining contents from 100 different cells, individually
selecting the cells become more cumbersome.
Is there a way to short cut this formula to pick up a range of cells I need
to combine the contents for?-- kind of how the reverse function of it works
for Text to Columns?
Thank you very much,
Storm