Another replace question

Mike · Sep 28, 2006

Hey guys! Thanks for the help on the last question!

Here is another one.

I have column A with this text:
sometexthere=moretexthere

What I need to do is make it like this with quotes:
sometexthere="moretexthere"

Any way to do this?

Thanks!!!

Mike

Toppers · Sep 28, 2006

Try:

=LEFT(A1,FIND("=",A1))&""""&TRIM(MID(A1,FIND("=",A1)+1,255)) &""""

Mike · Sep 28, 2006

Thanks Toppers!!!!

Toppers said:
Try:

=LEFT(A1,FIND("=",A1))&""""&TRIM(MID(A1,FIND("=",A1)+1,255)) &""""