replace the content of cell

  • Thread starter Thread starter Wu
  • Start date Start date
W

Wu

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?
 
Hi,

Put this in a helper column and drag down

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

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MERGING COLUMNS TO ONE 1
How do i do this? 3
Reverse Concatenate? 14
Formula for counting cells with value 'x' provided Col U = 'y' 5
Summing user defined ranges from other tabs within the same workbook 0
Max 1
Copy column header to next column, delete & delete every nth colum 1
VBA - Finding the odd one out 8

Back
Top