Microsoft Office Forums - View Single Post - Copying part of a cell to a new cell

Thread: Copying part of a cell to a new cell

View Single Post

Old

01-27-2012, 08:28 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

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

Reply With Quote