Name Reverse and setting Proper format (Excel)

[Shinianne]

Hi,

Can I please ask for help, this is the formula im using
=PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4)))

the result of the formula is at Name Row
=PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4)))


I wanted to make the name look like Abbas, Shin ,but i couldnt figure out how to do it.
can someone please help? thank you so much

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Member[/TD]
[/TR]
[TR]
[TD]Abbas Shin.[/TD]
[TD][TABLE="width: 133"]
<tbody>[TR]
[TD="class: xl67, width: 133"]shin.abbas[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[mohadin]

Hi
try

=PROPER(RIGHT(O4,LEN(O4)-SEARCH(" ",O4))&" "&LEFT(O4,SEARCH(" ",O4)))

You should be searching for space, Ok?

 

[Peter_SSs]

See if this does what you want.

Excel Workbook
	N	O
4	Abbas, Shin	shin.abbas
Name Reverse

 

[Shinianne]

See if this does what you want.

Name Reverse

	N	O
Abbas, Shin	shin.abbas

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:111px;"><col style="width:109px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula N4 =PROPER(MID(O4&", "&O4,FIND(".",O4)+1,LEN(O4)+1)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

This is great it worked! thank you so much

 

[Shinianne]

the name was formatted without space only a period, but this works for spaces indeed. thank you so much

 

[Peter_SSs]

This is great it worked! thank you so much

You're welcome. Thanks for the confirmation.