Remove first 2 characters & 1 spaces

[muhammad susanto]

hi guys..

it's possible using Find & Replace without excel formula to remove first 2 character & 1 spaces, like this below :

sample	after Find & Replace
CV ARGO NUSANTARA MULIA	ARGO NUSANTARA MULIA
CV PUJI LESTARI	PUJI LESTARI
PT NUANSA PERTIWI	NUANSA PERTIWI
PT RIAU EMPAT SEJATI	RIAU EMPAT SEJATI
etc...

<tbody>
</tbody>

any assistance will be appreciated...

m.susanto

 

[Momentman]

If its always 2 characters and a space, then
=RIGHT(A2,LEN(A2)-3)

 

[muhammad susanto]

hi Momentman..it work but how do without Formula?
like using the characters ?, <, >, /, *, &, $, =, etc...

please help me, it's possible?...

 

[Momentman]

Well, am not certain that can be done, considering your examples

If you had only one space like

CT MuSLIA
GT JAMES
KT SURAN

Then using find("?? ") and replacing with blank("") will work for removing the first 2 characters and a space

but because you have multiple spaces, I really cant say how to make it work

Note that the Find and replace doesnt require the quotes as i posted above

 

[muhammad susanto]

hi Momentman, you're right..
it work with using Find ?? Replace blank

thanks a lot...great!!