Copying Calculated Columns into Source Column

[ammdumas]

How do I copy a calculated cell into a cell where the source data comes from?
For example, in Cell D3 I have a formula =CONCATENATE("4601-",B3)which gets me "4601-1234".
Now I want to replace what's in B3 with what is in D3 without getting the REF#("1234" turns into "4601-1234"). Basically I'm replacing stuff.

 

[ExcelChick]

1. Copy column D.
2. Highlight column B.
3. Select from the menu bar Edit, then Paste Special. Choose the third option - Values.

This will replace the data in column B with just the values from column D, thus eliminating the formula.

 

[ammdumas]

Thanks. I knew it was something simple. I need coffee.