Copying part of a cell to a new cell

Catalin.B · #1 01-27-2012, 07:27 AM

There is more you can do:
Select the column C, which has formulas, right click on selection then paste back in the same range, but paste only values, so there will be no formulas on column C. Same thing on column E formulas, replace them with the values.
Then , with values in C and E columns,
put this formula in an empty column, same row: 1027:
=SUBSTITUTE(E1027;SUBSTITUTE(C1027;D1027;"");"")

This will remove from column d the data which exists on columns C and E.
Then select this range of substitute formulas, copy, paste only values back on column D.

paulw793 · #2 01-27-2012, 08:03 AM

Quote:

Originally Posted by Catalin.B

There is more you can do:
Select the column C, which has formulas, right click on selection then paste back in the same range, but paste only values, so there will be no formulas on column C. Same thing on column E formulas, replace them with the values.
Then , with values in C and E columns,
put this formula in an empty column, same row: 1027:
=SUBSTITUTE(E1027;SUBSTITUTE(C1027;D1027;"");"")
This will remove from column d the data which exists on columns C and E.
Then select this range of substitute formulas, copy, paste only values back on column D.

That formula isn't working correctly. When I enter it in all it does is give me the same value that is in column E and doesn't delete anything from column D.

Catalin.B · #3 01-27-2012, 08:28 AM

this is the right one, the other was written without testing, sorry.
=SUBSTITUTE(SUBSTITUTE(D1027;C1027;"");E1027;"")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM
Copying data from one cell to another automatically	mrphilk	Excel	4	06-10-2010 11:52 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM