How to return partical text?

[yichuansancun]

Hello -

I have the following:
<table style="width: 172px; height: 18px;" border="0" cellpadding="0" cellspacing="0"><col width="172"><tr height="17"> <td class="xl68" style="height: 12.75pt; width: 129pt;" height="17" width="172"> <table style="width: 455px; height: 180px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 129pt;" width="172"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; width: 129pt;" height="17" width="172">Santiago, Chile</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">San Jose, Costa Rica</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Mexico City, Mexico</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Bentonville AR, U.S.A.</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Miami FL, U.S.A.</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Sao Paulo, Brazil</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Dhaka, Bangladesh</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Mexico City, Mexico</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" height="17">Sao Paulo, Brazil</td> </tr> </tbody></table></td> </tr></table>
How can I ask Excel to turn the anything that is after ", "?

For example for Santiago, Chile, Excel should return "Chile".

Please note that there is a space after the ",".

Thanks

Perri

 

[shg]

=mid(a1, find(",", A1)+2, 255)

 

[Rick Rothstein]

Give this formula a try...

=TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",99)),99))

This formula assume that none of your text is longer than 99 characters. If it could be, then change the two 99s to any number larger than the largest number of characters you could possibly have in any one piece of text.

 

[yichuansancun]

Thanks, I was able to do it with the following formula

=MID(B7,FIND(", ",B7,1)+2,LEN(B7)-FIND(", ",B7,1))

Perri