Amanda has attended:
Excel Advanced course
Concatenate
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
RE: Concactenate
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
