Replace function start num to any value?

[palapeli]

Hi,

The output cells in excel file can be certainly done by other functions but I have used ISNUMBER and SEARCH. It works almost in every situation but "start num" in replace function is causing incorrect output.

[Phuocam]

Try ...

=TRIM(SUBSTITUTE(C2,B2,""))

[Richard Buttrey]

Use instead

Please Login or Register  to view this content.

[samba_ravi]

TRY G2=SUBSTITUTE(C2,B2,"")

Please Login or Register  to view this content.

and copy towards down

[palapeli]

Thanks for super fast replies Subtitute "a little bit" simpler than mine isnumber and search:D

[Richard Buttrey]

Hi,

Re your PM
I can't see anything that looks like personal information in the file.

Our general policy is to leave attachments since it sets the context for the question and may be useful for others.

Let me know which information is personal.

[Richard Buttrey]

I've removed your name from the File Properties and re-uploaded the file.