Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Use this code
=Trim(replace(replace(YourColumn,'Brand',''),'brand',''))
Rgds
Anand
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Use this code
=Trim(replace(replace(YourColumn,'Brand',''),'brand',''))
Rgds
Anand
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
See the attached sample file
Rgds
Anand
 
					
				
		
thanks Anand
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Thanks! You are welcome.
Rgds
Anand
