Thread: Equals updates only part of a cell

If I have a long string inside of a cell, lets say

UPDATE gtdb set camelot = '7A' WHERE major_key = 'D Minor'

Can I have excel use the Equals function on only part of the string? like this

(D Minor) = A13

Thanks for your help

Originally Posted by ChemistB

There are a whole slew of Functions (e.g. LEFT, RIGHT, MID) which can be used to return part of a text string. The question is, what do you want to tell Excel to return. An example workbook in which you show what you have and what you want would make this easier.

I want only a part of the Cell B1 to equal Cell A1

Example
Cell A1 Cell B1
"Something" "Cell A1 has 'Something' in it"

As you can see I want only part of cell B1 to equal cell A1

Originally Posted by teylyn

maybe like this

="UPDATE gtdb set camelot = '7A' WHERE major_key = "&A13

That nearly got it but it left out the single quote marks.
your code gave me: UPDATE gtdb set camelot = '7A' WHERE major_key = 6B
But i would like 6B inbetween single quotes like this:
UPDATE gtdb set camelot = '7A' WHERE major_key = '6B'

I think I may have reached the limitation???

Thanks a lot for your help guys

Originally Posted by Paul

Just add the single quotes into the string then:

="UPDATE gtdb set camelot = '7A' WHERE major_key = '"&A13&"'"

Thanks,

that almost got it I ended up with single quotes on one side and double on the other, but i changed it to this and now it does what I want it to
="UPDATE gtdb set camelot = '"&B2&" WHERE major_key = '"&A2&""
that renders out this:
UPDATE gtdb set camelot = 'A-Flat Minor' WHERE major_key = '1A'


Confusing really as I only have 2 single quotes in the code and it pumps out four!???
Just how I need it.

Thanks alot for sorting me out guys!