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

Name	Member
Abbas Shin.	shin.abbas <tbody> </tbody>

<tbody>
</tbody>

 

[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
4	Abbas, Shin	shin.abbas

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:111px;"><col style="width:109px;"></colgroup><tbody>
</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.