Forum home » Delegate support and help forum » Microsoft Excel Training and help » Concatenate
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Concatenate
Resolved · High Priority · Version 2003
Reply Tue 1 Jul 2008, 00:32Delegate 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
For upcoming training course dates see: Pricing & availability
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
|