• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Selecting particular quotes in the following texts

A

Ananthram.Gupta

New Member
Dear Team,

Please help me with replacing particular single/double quotes to any particular text/symbol.

Example: "9736837437", "info@thinkwisetech.com", "#906, 20th Cross, Location - 560030".

As per example, how can I change left single/double quote to one symbol and right single/double quote to another.

Note: There may be chances, where these quotes will be extra like in given example2: "#906, 20th Cross", Location - 560030"
 
Dear Chirayu,

Thanks for the quick response with solution. This almost meets my requirement. But here, I need other symbol apart from "%" for right quote(closing quote).
 
Ananthram.Gupta said:
Yes, for example left side will have "%" and right side will have a "^" symbol
Click to expand...
Maybe,

1] Data in Column A with header.

2] In B2, formula copied down :

=IF(LEFT(A2)="""",REPLACE(IF(RIGHT(A2)="""",REPLACE(A2,LEN(A2),1,"^"),A2),1,1,"%"),IF(RIGHT(A2)="""",REPLACE(A2,LEN(A2),1,"^"),A2))

Regards
Bosco
 
There is small doubt here.

Can we open and close quotes according to the order?

Like, 1st double quote which comes is replaced with "%" and next in the list(where ever it maybe) should be replaced with "^".

Example: "9736837437", "info@tech.com, "#906, 20th Cross, Location - 560030".

In the above example, "9736837437" will have "%" and "^" same way.. "info@tech.com, " will have other "%" and "^".

If there are no closing in quotes it can be "%(Left Double Quote)"
 
You must log in or register to reply here.
Back
Top