Hello:

I know how to use the CONCATENATE formula to combine two cells into one.
When I did so in a spreadsheet yesterday, a lot of space ended up between the
two sets of data in the combined cell. I ended up having to go through and
delete the blank space individually in a lot of the combined cells down the
column.

Perhaps, each of the two cells that I combined had a lot of space in each
cell after each piece of data. I don't know.

Is there any way to avoid having this additional space, in the future?

Also, I have a separate and unrelated question. I'd like to know what
keyboard shortcut that I can use in order to copy data from one cell in a
column to all of the rest of the cells in that column. Here's what I'm
getting at.

If I have a column that is over 3,000 rows long, I don't want to have to sit
in front of my laptop and hit the Shift-Page Down keys as that takes too long
to copy down. I once saw a guy literally do a similar copy, in just two
seconds. But, I do not know what he was doing with his keyboard.

Any help on that question would be greatly appreciated, also.

Thanks!

childofthe1980s