Copying and editing cells

**dgo** · 11-01-2006, 07:00 AM

Hi,

I have a list of cells with text in. I want to be able to copy all the cells into the next column, but delete the last 4 digits. For example in one cell it says EIBOR1W(RI) and I want the cell next to it to say EIBOR1W.

Sure there is an easy way, but can't for the life of me think of it!

Any help would be much appreciated.

Many thanks,
Dom.

**oldchippy** · 11-01-2006, 07:15 AM

Originally Posted by dgo

Hi,

I have a list of cells with text in. I want to be able to copy all the cells into the next column, but delete the last 4 digits. For example in one cell it says EIBOR1W(RI) and I want the cell next to it to say EIBOR1W.

Sure there is an easy way, but can't for the life of me think of it!

Any help would be much appreciated.

Many thanks,
Dom.

Hi dgo,

Try this,

=LEFT(A1,LEN(TRIM(A1))-4)

oldchippy