We're having to do a workaround for pulling supplier details out of a transaction list where the supplier name could be anywhere in the text and could be any length. Excel is able to flash fill the remainder once around 3 are typed, but these are not always standard (e.g. it may include LTD on one and not the other, even if the company names are the same).
What are my options to build a formula to standardise this? Is there anything I can do to get the flash fill to be more standardised? Using O365