Hi Frank,

Am Sat, 27 Jun 2015 14:54:47 -0400 schrieb :

Order Category Number
1 Catalog# 5100
2 INV 87500
3 CMPL 87000
4 Notes Red (bush)

Title: 5100-87500-87000-Red (bush)

But user Sue has her four catergores order defined as
INV-CMPL-Catago#-Notes, as shown below.

Order Category Number
3 Catalog# 5100
1 INV 87500
2 CMPL 87000
4 Notes Red (bush)

Title: 87500-87000-5100-Red (bush)

look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Concatenate" and download the workbook because macros are disabled
in OneDrive.
I wrote a UDF for your problem.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional