Probably the simplest method would be to use a helper column (C?) to
concatenate the name and Member ID. Per your example, if the ID is in
column A and the first name is in column B, then:

C1 =B1&A1

C1 would return "Mark1". copied down will return:

C2 Steve2
C3 John3
C4 John4.....

This column (C) can then be CopyPaste SpecialValues to remove the
formulas and list just the results. Delete column B (C becomes B) and
export to your MySQL file.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477506