Hi I’m trying to extract EFT information from the following cell PAYMENT BY AUTHORITY TO SG FLEET SALARY PACKAGING PTY LTD SGFLEET EFT587544
So there are 100s of transactions with such information above. I’d like to extract only EFT587544 in the next cell (in this example). The location and the lengths of EFT ID vary. So I can not think of way to do it. Could you help me to write macro to extract only EFT information and place it to the next cell? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
