How about just editing out the Ax, in top cell and copying that down to A1000?


Gord Dibben MS Excel MVP

On Sat, 27 Oct 2007 12:37:07 -0700, wrote:

Thiis is the formula:
=CONCATENATE(Master!$R$2,Master!$R$3,A2,Master!$R $4,Master!
$C2,D3,Master!$C3,Master!$C5,Master!$C8)
I want to remove the A2 part from all 1000 entries

On Oct 27, 2:45 pm, "RagDyeR" wrote:
Post your formula.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

wrote in message

ups.com...
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!