ExcelBanter - replace the content of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - replace the content of cell (https://www.excelbanter.com/excel-discussion-misc-queries/169220-replace-content-cell.html)

replace the content of cell

I have the following data:

A01-2007

A-01-2006

I Would like to replace the right hand side 5 characters, like below result:

A01

A-01

How can I do this?

Jim May

replace the content of cell

=LEFT(A1,LEN(A1)-5)

"Wu" wrote:

I have the following data:

A01-2007

A-01-2006

I Would like to replace the right hand side 5 characters, like below result:

A01

A-01

How can I do this?

Mike H

replace the content of cell

Hi,

Put this in a helper column and drag down

=LEFT(A1,LEN(A1)-5)

Mike

"Wu" wrote:

I have the following data:

A01-2007

A-01-2006

I Would like to replace the right hand side 5 characters, like below result:

A01

A-01

How can I do this?

Max

replace the content of cell

This might suffice ..
In B1, copied down: =LEFT(A1,LEN(A1)-5)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Wu" wrote:
I have the following data:

A01-2007

A-01-2006

I Would like to replace the right hand side 5 characters, like below result:

A01

A-01

How can I do this?

All times are GMT +1. The time now is 10:08 PM.