Thread: Is there a formula to transpose numbers, e.g. change 36 to 63
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Is there a formula to transpose numbers, e.g. change 36 to 63
If it is always a 2 digit integer, you could use =LEFT(A1)+10*RIGHT(A1)
--
David Biddulph

wrote in message
ps.com...
Using Excel is it possible to 'transpose' numbers

e.g. 48 becomes 84?



Reply With QuoteReply With Quote