remove chars from cell content

  • Thread starter Thread starter itty
  • Start date Start date
I

itty

I got part numbers like WGL6068 in a range of coloum. I want to remove
GL from the cell and make it W6068. Can anybody help ?
Thanks
 
Hi

Try using
=LEFT(A2,1)&RIGHT(A2,4)
in the adjacent cell. You can then autofill this down, copy and paste
values.

Andy.
 
I got part numbers like WGL6068 in a range of coloum. I want to remove
GL from the cell and make it W6068. Can anybody help ?
Click to expand...

If A1 contains "WGL6068", a cell with the formula
=REPLACE(A1,2,2,"")
will show "W6068".
 
Hi

Select the range with part numbers. From menu, select Edit.Replace, enter
"WGL" for string to search, and "W" for string to replace with, and then
click on ReplaceAll.
 
If A1 houses WGL6068

In Cell B1 enter :

=SUBSTITUTE(A1,"GL","")

Then, will return W6068

Regards
 
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

Trim Numbers 3
Time Duration Calculation help needed 4
searching 2 values from 2 cells 5
Lookup value needed 3
Consolidate 1
Help with a formula please. 2
How to match the Coloums 1
Lookup returning wrong results 0

Back
Top