CODEWITHSUNDEEP
sqlexcelvba
Alex Gordon
Alex Gordon

Reputation: 60811

excel quotes in formula question

i have a column with this data:

IT_AMPH
IT_BARB
IT_BENZ
IT_BUP
SOMA

i want the column next to it to be literarely 

=like "*,IT_AMPH,*"
=like "*,IT_BARB,*"
=like "*,IT_BENZ,*"
etc

please note that i want the equal signed to be displayed, exactly as shown above

what would be the formula for this?

Upvotes: 0

Views: 155

Answers (2)

Thomas
Thomas

Reputation: 64655

="=like ""*," & A1 & ",*"

Excel is smart enough to know that the string you are creating is not itself a formula. Btw, this really belongs on superuser.com instead of stackoverflow.

Upvotes: 1

Gabriele Petrioli
Gabriele Petrioli

Reputation: 196132

this should do it..

="=like ""*," & othercolumn & ",*"""

Upvotes: 1

Related Questions