how to segregation only person name in a data row

[GVN KUMAR]

sir, i am received a data file
a three columns data mixing in one column sir
like id no + name + designation mixing ↓ below data in
" 0729541 NARAYANA RAO PALLEBOYINA School Assistant "
Name only capital letters as a special characters some line data all are small characters

but we are unable to using find and replace with wild charter but not possible sir due to no special characters.

any special formula required for name only taking out put result

"NARAYANA RAO PALLEBOYINA"

 

[GraH - Guido]

Hi Kumar, please upload a sample file if you will. Like this, difficult to give a suggestion that might work.

 

[GVN KUMAR]

Sir sample file attached sir

sorry for late (today our new day sir)
thank you sir

 

[Khalid NGO]

Hi Kumar,

Your sample file contain just one example ?

Check this {array} formula:

=MID(B2,MATCH(1,(CODE(MID(B2,ROW($1:$255),1))>=65)*(CODE(MID(B2,ROW($2:$255),1))<90),),MATCH(1,(CODE(MID(B2,ROW($1:$255),1))>=97)*(CODE(MID(B2,ROW($2:$255),1))<=122),)-FIND(" ",B2)-2)

{array formula needs to be entered with
key combination of Ctrl+Shift+Enter}

This should work if the pattern is same.

Regards,

 

[rahulshewale1]

Hii @GVN KUMAR ,


Use flash fill it's working fine.

https://trumpexcel.com/flash-fill-excel/


Regard
Rahul shewale

 

[GVN KUMAR]

Sir
working amazing big formula bling apply sir its 200% accurate working sir
excelent sir thank you sir khalid ngosir
thank you a lot sir (big formula amazing formula) wow

rahul shewale1
sir ur idea ok but its accurate not working sir