I have a column of about 1000 entries. It is a very long Concatenate
formula. Within the formula there is a reference to another column
which I no longer want to include. Is there a way to modify all these
entries to remove that reference? If it was a static value I would
just do a search and replace but the part I want to remove is
different on each row (for example, A1 on the first row, A2 on the
second and so on, up to A1000. I want to remove them all)

any ideas?

Thanks in advance!