View Single Post
  #5   Report Post  
Shirley
 
Posts: n/a
Default

Thanks!! This board sure is a help and a time saver! I'm thankful for those
that take the time to respond.
--
Shirley


"swatsp0p" wrote:


A slight correction will make it work:

=LARGE(A1:A5,1)&"\"&LARGE(A1:A5,5)

note the addition of the '&' after the "\" as well as in front of it.

Good Luck

Bruce


--
swatsp0p


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