Hi,

Well, I think you may be looking for this

=""""&IF(LEN(LEFT(A1,FIND(",",A1)+1))=4," ","")&LEFT(A1,FIND(",",A1)+1)
--
Thanks,
Shane Devenshire


"Uma Nandan" wrote:

Hi,

Please find below my data:
I have some data as mentined in current data

I would require the out put as mentioned in Required output column.
can some one help me with this?

I have 10k Data where in i need to use this double quotes.


Current Data Required Output
VP, Engineering Governance " VP, Engineering Governance "
CEO, Global Investment Banking "CEO, Global Investment Banking"

Thanks in advance.

Regards,
Uma