how to remove "= sign"

[omairhe]

Hi...looking for a formula to remove an "= sign" at the very beginning. hence if "=Jordan" then want to change it to "Jordan" in cell T3 only.

but wait, the resulting cell T3 "=Jordan" already has a formula inside it =(U3&V3&W3&X3&Y3)

How to enter formula for removing "= sign" and not disturbing the existing formula ....


Will appreciate help!!

 

[wsjackman]

select the cell
use edit, paste special, values

 

[Richard Schollar]

Are you saying:
=(U3&V3&W3&X3&Y3)

results in the value "=Jordan" appearing in the cell? If so, you could use:

=MID(U3&V3&W3&X3&Y3,2,1024)

 

[Peter_SSs]

Or possibly one of these?

=REPLACE(U3&V3&W3&X3&Y3,1,1,"")

=SUBSTITUTE(U3&V3&W3&X3&Y3,"=","")

 

[omairhe]

Thank you all the formula works flawlessly...

Appreciate it a lot

 

[Peter_SSs]

Thank you all the formula works flawlessly...

Appreciate it a lot

Just note that if it is possible that U3&V3&W3&X3&Y3 could result in a string that does not start with "=" then the SUBSTITUTE version would be best as the other two will strip off the first character no matter what it is (unless that is what you want anyway ).

 

[omairhe]

hi well the = sign is always going to be there unless i change the formula for the cell that causes this.

the cell is U3 =AutoFilter_Criteria(U60) this results in = sign in cell T3

is possible to apply formula directly on U3 to remove the = sign

 

[omairhe]

i have it in detail over this post http://www.mrexcel.com/forum/showthread.php?p=2125319#post2125319

but no worries changing T3 is a good idea also

 

[Peter_SSs]

hi well the = sign is always going to be there unless i change the formula for the cell that causes this.

the cell is U3 =AutoFilter_Criteria(U60) this results in = sign in cell T3

is possible to apply formula directly on U3 to remove the = sign

Yes, you could apply any of the suggested formula structures to U3 if you want, and return T3 to what it was before.

 

[omairhe]

Yes, you could apply any of the suggested formula structures to U3 if you want, and return T3 to what it was before.

the problem here seems to be with two words for instance If "=Jordan Michael" in U3 then the formula in U3 =MID(AutoFilter_Criteria(U60),2,1024) results in only "Jordon" on T3 without the rest of &V3&W3&X3&Y3) formula working aswell. but its working fine with only one word eg "=Jordan"

Thanks for yr interest in this matter.