ExcelBanter - how do i transpose letters using a functionl?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i transpose letters using a functionl? (https://www.excelbanter.com/excel-worksheet-functions/120306-how-do-i-transpose-letters-using-functionl.html)

solvera

how do i transpose letters using a functionl?

does anyone know?

Gary''s Student

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?

Niek Otten

how do i transpose letters using a functionl?

What do you mean with "transpose"? "letters"? "function"?
All these words have many meanings. Please try and explain what you are trying to achieve.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"solvera" wrote in message ...
| does anyone know?

All times are GMT +1. The time now is 12:10 AM.