Hi Karen, if I understand correctly, you have a list of postal codes that are
a horizontal vector and you'd like them to be vertical. If that's right, you
can copy the list then, in cell G1, paste special and select the "Transpose"
option.

"KarenScott" wrote:


Hi There

Could you please help? I have a small database which needs to be sorted
correctly by postcode but I can't get it to work. Eg the list goes G1,
G11, G12 etc where it should go G1 G2 G3 etc.

Does anyone know of a sorting solution?

Thanks
Karen:)


--
KarenScott
------------------------------------------------------------------------
KarenScott's Profile: http://www.excelforum.com/member.php...o&userid=35337
View this thread: http://www.excelforum.com/showthread...hreadid=551056