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
 
Back
Top