Correct name

Hi Shiima,

Try this one for the name in A1:
=UPPER(RIGHT(A1,1))&MID(A1,2,LEN(A1)-2)&LEFT(A1,1)

Is second example a mistake ?

Any way
Try this :
=CONCATENATE(RIGHT(A1,1),MID(A1,2,LEN(A1)-2),LEFT(A1,1))

The desired results do not obey your specification?

Very wonderful solutions mister "Yesterdays" and Mister "Vidar"
Thank you all
But if the name, such as this
retep oarcM ntefanS

With an UDF (User Defined Function)

Result:
<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='3' style='font-family:Arial; color:#000000; background-color:#FFFFFF; font-size:10px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='60pt'><col width='60pt'></colgroup><tr style='background-color:#cacaca'><td> </td><td align='middle'>A</td><td align='middle'>B</td></tr><tr><td style='background-color:#cacaca' align='middle'>1</td><td align='left' >saxeT</td><td align='left' >Texas</td></tr><tr><td style='background-color:#cacaca' align='middle'>2</td><td align='left' >amabalA</td><td align='left' >Alabama</td></tr><tr><td style='background-color:#cacaca' align='middle'>3</td><td align='left' >awoI</td><td align='left' >Iowa</td></tr><tr><td style='background-color:#cacaca' align='middle'>4</td><td align='left' >eniaM</td><td align='left' >Maine</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Cell</td><td>Formula</td></tr><tr><td>B1</td><td><Span style='color:#222222'>=mirror</Span><Span style='color:#0000DD'>(A1)</Span><Span style='color:#222222'></Span></td></tr></table>

Matt Rogers said:

With an UDF (User Defined Function)

Code:

Public Function Mirror(rngCell As Range) As Variant
Mirror = StrReverse(rngCell.Text)
End Function

Result:

	A	B
1	saxeT	Texas
2	amabalA	Alabama
3	awoI	Iowa
4	eniaM	Maine

<colgroup><col style="width: 28ptpx"><col width="60pt"><col width="60pt"></colgroup><tbody>
</tbody>

Cell	Formula
B1	=mirror(A1)

<colgroup><col style="width: 40ptpx"><col></colgroup><tbody>
</tbody>

Click to expand...

This just reverse the name, not switching first and last letter of the name

shimaa01234 said:

But if the name, such as this
retep oarcM ntefanS

Click to expand...

That requires a totally different solution than the question you asked originally. Give this UDF a try...

HOW TO INSTALL UDFs
------------------------------------
If you are new to UDFs, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are done. You can now use RevBeginEnd just like it was a built-in Excel function. For example,

=RevBeginEnd(A1)

If you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.

Vidar said:

Hi Shiima,

Try this one for the name in A1:
=UPPER(RIGHT(A1,1))&MID(A1,2,LEN(A1)-2)&LEFT(A1,1)

Click to expand...

That doesn't produce Marco nor Stefan. Are you not assuming to much about the specification and the inputs that are given? The inputs and the results the OP expects are reposted below...