Thread: Is there a formula to transpose numbers, e.g. change 36 to 63
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
Randy Harmelink Randy Harmelink is offline
external usenet poster
  
Posts: 122
Default Is there a formula to transpose numbers, e.g. change 36 to 63
If the number is in cell E5, this array-entered formula should do the
trick:

=SUM(10^(ROW(A1:A50)-1)*MID(E5&REPT("0",50),ROW(A1:A50),1))

On Sep 20, 1:36 pm, wrote:
Using Excel is it possible to 'transpose' numbers

e.g. 48 becomes 84?


Reply With QuoteReply With Quote