I would like to insert a string of text at the beginning of whatever else in a cell.
For example, the cell may contain: "1E. Aerosol cleaners containing non-halogenated solvents and petroleum distallates."
I would like to insert this: "1G. Product not acceptable for the material reuse program." right before "1E. Aerosol cleaners containing non-halogenated solvents and petroleum distallates."
I know I can run an update query to just add 1G after the 1E, but I need this in alphabetical order.
TIA
For example, the cell may contain: "1E. Aerosol cleaners containing non-halogenated solvents and petroleum distallates."
I would like to insert this: "1G. Product not acceptable for the material reuse program." right before "1E. Aerosol cleaners containing non-halogenated solvents and petroleum distallates."
I know I can run an update query to just add 1G after the 1E, but I need this in alphabetical order.
TIA