Need to Split Uppercase word in a sentance

[harinsh]

Hi Team,

I need one function where I can split word based on 'Uppercase'. Can anyone please help me with below requirement.

Please find the below reference data and also note that in this given data only we can find upper case word at the end of the sentence.

<table border="0" cellpadding="0" cellspacing="0" width="296"><colgroup><col style="mso-width-source:userset;mso-width-alt:10825;width:222pt" width="296"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:222pt" height="20" width="296">Bank of Ghana ACCRA </td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Bank of Ghana AGONA SWEDRU </td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Bank of Ghana TAKORADI </td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Bank of Ghana SEFWI BOAKO </td> </tr> </tbody></table>

-- removed inline image ---


Thanks,
Harish Kumar

 

[Rick Rothstein]

...but also I would like to know do we have the funkcion for this.

Assuming your first text string is in cell A2 (Row 1 being headers), put the following array-entered** formula in cell B2...

=LEFT(A2,MAX(IF(ABS(CODE(MID(A2,ROW(INDEX(B:B,1):INDEX(B:B,LEN(A2))),1))-109.5)<=12.5,ROW(INDEX(B:B,1):INDEX(B:B,LEN(A2))))))

** Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

and put this normally-entered formula in cell C2...

=MID(A2,LEN(B2)+2,100)

 

[Marin30]

Whay can't apply this funkcion, do not work?
Can I send to you excel fail?
thnx

 

[hiker95]

Whay can't apply this funkcion, do not work?
Can I send to you excel fail?
thnx

You may want to see the Forum Rules, Rule #4:, at the next link:

http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[István Hirsch]

In your excel version what is the argument separator, "," or ";" ?