concatenate question

  • Thread starter Thread starter bob green
  • Start date Start date
B

bob green

I have data from 1270 people. I want to join a number of columns for
each individual using concatenate - e.g =CONCATENATE
(a1,b1,c1,d1,e1,f1).

Other than performing 1270 search & replaces or cut and pastes for the
original formula how can I more efficently do this?

Any assistance is appreciated,

Bob
 
Bob;

One way to accomplish this takes just a few keystrokes.
It assumes that all the data is in one continuous block
from top to bottom.

[1] Create a working formula in the top row of data and
make sure it works the way you want it to.

[2] Remember to press Enter to complete the formula. No
offense, just making sure. :-)

[3] Re-select the cell with the working formula in it.

[4] Press CTRL + SHIFT + Down Arrow. This selects all
cells in a continuous block of data. (You can use it more
than once if there is a blank row somehwere in your data -
if you go too far press CTRL + SHIFT + Up Arrow.)

[5] Select Edit - Fill - Down (or press CTRL + D).

[6] You're done.
 
Back
Top