I am using the concactenate function and have now managed to construct a sentence, by entering cell content in columns A - M, placing " " in alternate text_line no to represent spaces.

I now need to insert a new columm to be new column A. How can I refresh concactenate function so that the new A column/cell content is at the beginning of the constructed sentence?

Regards

Amanda

Hi Amanda

If your function looks like this

=CONCATENATE(A4," ",B4," ",C4," ",D4," ",E4," ",F4)

When you insert a new column in Position "A" it is outside the function parameters so the function looks like this

=CONCATENATE(B4," ",C4," ",D4," ",E4," ",F4," ",G4)

The best way to fix this is by clicking the function cell and going into the formula bar and editing the function by adding the A4 and the " " (Space) as seen below

=CONCATENATE(A4," ",B4," ",C4," ",D4," ",E4," ",F4," ",G4)

Hope this helps

Carlos