Concatenate

Resolved · High Priority · Version 2003

Tue 1 Jul 2008, 00:32 Delegate Amanda said...

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

Tue 1 Jul 2008, 13:01 Trainer Carlos said...

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

Excel tip:

Currency format

Ctrl+Shift+$ applies the Currency format, with two decimal places

View all Excel hints and tips

Concatenate

Concatenate

RE: Concactenate

Excel articles

Excel tip:

Currency format