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

Question 1: =TRIM(A1)

Question 2:
Select first row
Keep Ctrl and Shift pressed
Press down arrow

HTH
--
AP

"childofthe1980s" a écrit dans
le message de ...
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

Hi,
Use TRIM function to remove leading/trailing blanks

e.g =Concatentate(Trim(A1),"-",TRIM(B1)) will combine A & B with - between
e.g. ABC-DEF

Re copying one cell to ALL others below it:

Select source cell and then COPY
Select next cell down (Source+1), SHIFT+CTRL + Down Arrow to take you to
bottom of your column, then PASTE.

HTH

"childofthe1980s" wrote:

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

See Ardus reply for copy - easier than mine!

"childofthe1980s" wrote:

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

My first posting, so if I'm doing this incorrectly, let me know.

Regarding question 2: When I want to do a quick "fill-down", I copy the
cell (ctrl+C), then select the first receiving cell & paste (ctrl+V).
With that cell active, I double click on the fill box and voilla! it
will fill down to the end of the last active row in that column.

Let me know what you think.

seagee69