Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I take the following:
a1 Dave Jones b1 888 Any Street Hometown, NY 11111 a2 Sally Jones b2 888 Any Street Hometown, NY 11111 a3 Joe Smith b3 899 Any Street Hometown, NY 11111 a4 Ann Smith b4 899 Any Street Hometown, NY 11111 a5 Sam Brown b5 902 Any Street Hometown, NY 11111 a6 John Evans b6 999 Any Street Hometown, NY 11111 etc. and turn it into: a1 Dave Jones Sally Jones b1 888 Any Street Hometown, NY 11111 a2 Joe Smith Ann Smith b2 899 Any Street Hometown, NY 11111 a3 Sam Brown b3 902 Any Street, Hometown, NY 11111 a4 John Evans b4 999 Any Street, Hometown, NY 11111 Thanks. Ken |