Example

Hyphen between columns

Sheet 1

A -B -C -D

234 -widget- 44 -LD2M34
567 -gadget -76- LD2M76
789 -top -39- LD2M95


Sheet 2

A -B -C -D

BLDG1 -75- 99- LD2M95
BLDG4 -45 -27 -LD2M34

Desired Output in third worksheet

A -B -C -D -E- F- G -H
234 -widget- 44 -LD2M34- LD2M34 -BLDG4 -45 -27
789 -top -39 -LD2M95 -LD2M95 -BLDG1 -75 -99
567- gadget -76- LD2M76


--
RayB
------------------------------------------------------------------------
RayB's Profile: http://www.excelforum.com/member.php...o&userid=33499
View this thread: http://www.excelforum.com/showthread...hreadid=559443