ExcelBanter - Another replace question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Another replace question (https://www.excelbanter.com/excel-discussion-misc-queries/112012-another-replace-question.html)

Mike

Another replace question

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

Another replace question

Try:

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

"Mike" wrote:

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

Mike

Another replace question

Thanks Toppers!!!!

"Toppers" wrote:

Try:

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

"Mike" wrote:

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

All times are GMT +1. The time now is 02:44 PM.