-Hi - was reading through the responses on this one and I have one question
please, I have two columns involved (last name first name) so changed the
formula a little to =IF(A168&B168=0,"ZZZ",A168&" "&B168) which does give me
last name space first name in the new column but when I then sort - all the
o's still go to the top rather than to the bottom - what have I done wrong
please?
--
Thanks

Lise


"Bryan Hessey" wrote:


Thanks for the response Sue, and the use of 3 Z's will ensure that names
beginning with Z will be sorted in their sequence.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=389531