S Shabbo Member Apr 16, 2020 #1 Dear Sir, I wanted ledger name mentioned in between ‘ Ledger Name’ Attachments Ledger name formula.xlsx 8.9 KB · Views: 8
B bosco_yip Excel Ninja Apr 17, 2020 #2 In B2, copied down ; =MID(A2,FIND("'",A2)+1,FIND("' ",A2)-FIND("'",A2)-1)