remove chars from cell content

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
 
A

Andy B

Hi

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

Andy.
 
M

Michael Bednarek

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".
 
A

Arvi Laanemets

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.
 
B

Bosco

If A1 houses WGL6068

In Cell B1 enter :

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

Then, will return W6068

Regards
 
Top