Have you tried using the "&" operator? For example, to get LAST & FIRST &
MI, use:

"=Dxx & ", " & Exx & " " & Fxx" where 'x' is the row number and D,E,& F
refer to the correct sheet.

As to putting multiple values in the same cell, yes, you can do that. To
enter multiple lines in the same cell, use ALT+ENTER.

I would caution you to think about why you want multiple people in the same
cell. You will likely need to use a macro to enter the multiple names
quickly enough, but if you use the "&" operator, you only need formulas.
Instead of multiple entries per cell, consider sorting and using functions.

BTW, if you do decide to use macros, the VBA equivalent of ALT+ENTER is
CHR(10).

HTH,
Matthew Pfluger

"Suzanne" wrote:

I have a worksheet whe
Row 1 is the header row
A2:Axx is UIC
B2:Bxx is BLDG
C2:Cxx is ROOM
D2:Dxx is LAST [name]
E2:Exx is FIRST [name]
F2:Fxx is MI [middle initial]

I've tried to get a merge to work in Word, but have been told what I need to
do is impossible (Word cannot merge data from two separate fields). So,
perhaps this might work from the Excel side.

I'm holding out for some hope that Excel can group multiple values on
another worksheet -- otherwise, I'm stuck having to copy paste data onto each
form in Word. Can I get the following results from Excel?:
Column A: UIC & BLDG & ROOM
Column B: LAST & FIRST & MI

The UIC & ROOM will always be in the same BLDG
The UIC is not the same for each ROOM (this is what Word merge can't do)

The output would look something like:
(Header Row)
A1: UIC; BLDG; ROOM
B1: LAST, FIRST, MI

A2: W1234; 456; 12A
B2: Jones, Mary L
Smith, Joe S
Doe, Adam D

A3: W3456; 456; 12A
B3: Black, Alan F
White, Barbara T

A4: W3456; 456; 99A
B4: House, Jill S [and so on]

You see that:
o The BLDG stayed the same for all three rows;
o Rows 2 & 3 have the same ROOM;
o Rows 3 & 4 have the same UIC but not the same room;
o The names column B are stacked (not one long string)
o There is a separate form for each UIC + ROOM

BTW: I also have the form in Excel whe
(First page)
K3 = UIC
P3 = BLDG
U3 = ROOM (note: I can merge these together if needed)
(Second page)
A52:Axx = LAST
G52:Gxx = FIRST
N52:Nxx = MI (note: I can merge these together if needed)

Thanks -- Suzanne