I';m sure there are several approaches. Here's mine:
Enter data in A2 123-45-6789
Enter position number for each number in B1:J1 {1,2,3,5,6,8,9,10,11}
B2=MID($A2,B$1,1) copied across row 2
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=379487