Correct name

[shimaa01234]

I have a Group of names I want to correct names
So that the first letter is the last
The last letteris the first letter
Such an example

retep	Peter
oarcP	Marco
ntefanS	Stefan

<tbody>
</tbody>

 

[shimaa01234]

The result full name
"Peter Marco Stefan"

 

[shimaa01234]

Yes, Mister "Vidar"
CODE works nicely
You also mister "Rick"
CODE works nicely, but is it possible to do so as the result by formula
Because I love more formula

 

[Aladin Akyurek]

Yes, Mister "Vidar"
CODE works nicely
You also mister "Rick"
CODE works nicely, but is it possible to do so as the result by formula
Because I love more formula

How does oarcP become Marco?

 

[shimaa01234]

Unfortunately Mister "Aladin"
I made the mistake in the letter

 

[Aladin Akyurek]

Unfortunately Mister "Aladin"
I made the mistake in the letter

That appears to be the case in 2/3 of the input cases. That's whay of the question in post #4...

Does all this mean that this is:

retep	Peter
arcoM	Marco
tefanS	Stefan

<COLGROUP><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3328" width=94><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3271" width=92><TBODY>
</TBODY>

what you have actually meant?

 

[shimaa01234]

I mean, if the name is composed of three or four names
How is the ranking by the formula

 

[Aladin Akyurek]

I mean, if the name is composed of three or four names
How is the ranking by the formula

Sorry I don't understand what you are asking...

 

[R Pelle]

.

 

[István Hirsch]

As you can see the formula solution is a bit long. Enter the formula below in B2 and C2 resp., then copy the formula in C2 across as long as needed. If there are four names, concatenate columns C – F in cell B2:

Enter in B2:

=C2&" "&D2&" "&" "&E2&" "&F2

C2 (and copy across):

=REPLACE(SUBSTITUTE(REPLACE(TRIM(MID(SUBSTITUTE(" "&$A2," ",REPT(" ",99)),COLUMNS($A:A)*99,99)),2,0,(RIGHT(TRIM(MID(SUBSTITUTE(" "&$A2," ",REPT(" ",99)),COLUMNS($A:A)*99,99)),1)))&"ß",RIGHT(TRIM(MID(SUBSTITUTE(" "&$A2," ",REPT(" ",99)),COLUMNS($A:A)*99,99))&"ß",2),LEFT(TRIM(MID(SUBSTITUTE(" "&$A2," ",REPT(" ",99)),COLUMNS($A:A)*99,99)),1)),1,1,"")

*	A	B	C	D	E	F
1	*	*	*	*	*	*
2	ntefaS oarcM reteP ialV	Stefan Marco *Peter Vali	Stefan	Marco	Peter	Vali
3	ntefaS oarcM reteP	Stefan Marco *Peter	Stefan	Marco	Peter	*
4	ntefaS oarcM	Stefan Marco *	Stefan	Marco	*	*
5	ntefaS	Stefan * *	Stefan	*	*	*

<colgroup><col style="width:30px; "><col style="width:170px;"><col style="width:176px;"><col style="width:71px;"><col style="width:68px;"><col style="width:67px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[shimaa01234]

You always give me the genius solutions Thank you very much, Mr." Istvan Hirsch" Solution is really a genius