Copying Concatenated cells down a data range

davejago

Board Regular
Joined
Apr 29, 2005
Messages
133
I am combining a whole cell with part of a cell. My formula is:

=Concatenate(D3,(RIGHT(A3,5)))

The problem is when I copy the cell down the entire 5000 row data range, the end result stays the same. When I visit each cell manually and change the 5 to another number (say 4) it changes to the correct value. I then switch back to the 5 and it works fine.

Why is excel doing this? Is there a way around this? I haven't got the time to do into each cell and do this manually!

any ideas?
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
You probably have your calculations set to Manual.

Go to Tools|Options, select the Calculation tab and select Automatic in the Calculation section.

Click Ok.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top