Or some formulas to do the same thing

Assumes list starts in A2
B1 = Group
C1 = Team
D1 = Person

Group
=IF(LEFT(A2,LEN($B$1))=$B$1,RIGHT(A2,LEN(A2)-FIND(" ",A2,1)),"")

Team
=IF(LEFT(A2,LEN($C$1))=$C$1,RIGHT(A2,LEN(A2)-FIND(" ",A2,1)),"")

Person
=IF(LEFT(A2,LEN($D$1))=$D$1,RIGHT(A2,LEN(A2)-FIND(" ",A2,1)),"")

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569602