How to extract capitalize letter text at certain position

Sorry harimin. Here is a new formula that should give the results you want.

Formula:

=MID(RIGHT(A2,25),AGGREGATE(15,6,FIND(CHAR(ROW(A$65:A$90)),RIGHT(A2,25)),1),25)

v	A	B	C
10	CUSTOMER	DEBIT	CREDIT
11	JAMES BOND	12,000
12	CHRISTINE		10,000
13	AMANDA B GREEN		25,025
14	JOSH BROWN		5,000
15	CHRISTINE		1,000
16		12,000	41,025