PierremontQuaker03
New Member
Hi, thanks for looking. See attached an extract from a bank statement, from the description, I am wanting a formula to pick out all the SL and SIP information from the cell and put it into a new cell. So for example for cell A1 - there is an "SL" in the cell - so I want the formulae to return "SL 289909", so return the nine digits including the combined letters "SL". Does that makes sense? The ability to change the number of digits easily would be good just in case we need to increase the numbers.