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 :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]sample[/TD]
[TD]after Find & Replace[/TD]
[/TR]
[TR]
[TD]CV ARGO NUSANTARA MULIA[/TD]
[TD]ARGO NUSANTARA MULIA[/TD]
[/TR]
[TR]
[TD]CV PUJI LESTARI[/TD]
[TD]PUJI LESTARI[/TD]
[/TR]
[TR]
[TD]PT NUANSA PERTIWI[/TD]
[TD]NUANSA PERTIWI[/TD]
[/TR]
[TR]
[TD]PT RIAU EMPAT SEJATI[/TD]
[TD]RIAU EMPAT SEJATI[/TD]
[/TR]
[TR]
[TD]etc...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!!