Currently, I have a long list of educational institutions with their names in quotes. The list was compiled by many people so formatting isn't coherent. I am trying to make the entire list Title Case but the change case plugin is stuttering if I have a letter right after a quotation mark ;
i.e. If the content looks like this - "A
instead of - " A
The plugin makes it lowercase.
So in order to solve this issue I need to find a way to insert a space after every quotation mark in the list/ a space after every first quotation mark on every row.
Any idea how I can do that?
CodePudding user response：
You may try SUBSTITUTE() function like-
=SUBSTITUTE(A1,CHAR(34),CHAR(34)&" ",1)
CodePudding user response：
In one cell formula
Use this formula to get rid of quotation marks and get names in
Functions used
