Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Concatenate
Resolved · High Priority · Version 2003
Amanda has attended:
Excel Advanced course
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
|
Excel tip:Currency formatCtrl+Shift+$ applies the Currency format, with two decimal places |
We'll call during UK business hours
Server loaded in 0.1 secs.