I am using excel 2019 advanced filter on a set of security symbols. Symbols are from 1 to 4 characters. I need to proceed the symbol with ="= and append " after the symbol. I can do this manually but since I need to repeat the process often multiple times a day on many symbols I would like a formula I could put into the column to the right that would put the symbols in the proper form e.g. from PM to ="=PM" and the latter will resolve to =PM after exiting the cell. Is this possible?