replace command

[Guest]

Hi, I used the replace command as follow:
=REPLACE(J474,FIND("/",J474),255,"") but now I see in my file that is not
only a slash i have in my format column. Can anybody have a way to specify,
if do not find the slash just copy the content.
Here are some exemple what i can find other than my slash:
120 g
50 Livret
200's
25 Refill
This is other than an slash but i need to copy them not replace.

Thanks

 

[Guest]

One way

=IF(ISNUMBER(FIND("/",J474)),REPLACE(J474,FIND("/",J474),255,""),J474)


Regards,

Peo Sjoblom

 

[Guest]

Thank You it's working

One way

=IF(ISNUMBER(FIND("/",J474)),REPLACE(J474,FIND("/",J474),255,""),J474)


Regards,

Peo Sjoblom