Under ToolsOptionsEdit do you have "Allow cell drag and drop" enabled.

Must be enabled for Pete's copy method to work.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 17:11:01 -0700, Annxqz
wrote:



"Pete_UK" wrote:

Assuming your last name is in A2, first name in B2 and maiden name in
C2, then enter this formula in D2:

=A2&", "&B2&" ("&C2&")"

and copy this formula down as necessary. Note that this does not check
for blanks, so if you do not have a maiden name you will have " ()" at
the end of the combined names. If all the cells are blank, you will get
" , ()"

Hope this helps.

Pete

Annxqz wrote:
I am trying to combine 3 columns. I have watched the demo and the drag
feature to get the other cells to merge won't work. I also have (brackets)
around the 3rd column and it won't show in the combined cell. Is there any
way to make it show up with the brackets? I am trying to combine last name,
first name, maiden name of women (with brackets around it) to designate
maiden name.

Pete, thanks for the answer, but I still can't get the drag feature to work. The formula populates D2 and now has the maiden name, but when I highlight it and drag down the D column to put the others in the column like D2 I get nothing but a blank cell all the way down the column. The demo says you don't have to enter a formula in each cell, just highlight and drag and it will do it for you. What am I doing wrong?