advanced cleaning string

[#1]

i have a data like this

abc brand

cde

fgh

ijk Brand

i need a formula where i can omit the word "Brand" if it is exist in data and need result like this

abc

cde

fgh

ijk

any answer?

thanks

Lavi

[its_anandrjs · Accepted solution]

Hi,

Use this code

=Trim(replace(replace(YourColumn,'Brand',''),'brand',''))

Rgds

Anand

[its_anandrjs]

Hi,

See the attached sample file

Rgds

Anand

[#4]

thanks Anand

[its_anandrjs]

Hi,

Thanks! You are welcome.

Rgds

Anand