Thread: how do i transpose letters using a functionl?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do i transpose letters using a functionl?
If you have two characters in a cell, say ME in cell A1, then:

=MID(A1&A1,2,2)

will produce the transpose, namely EM
--
Gary's Student


"solvera" wrote:

does anyone know?
Reply With QuoteReply With Quote