Quotation marks on select text in cell

Hello,

First post, so apologies if none of the following makes sense!

Looking to automatically add quotations marks to certain text in a cell, but have the text that follows not in quotation marks. ( Tried \”@\” in Format but this add them to the entire cell contents)

Is this possible? If so, how and what's the best way to make all cells do this?

Each cell needs to look like the following (the parts in bold will be manually added)

"TEXT" OR at_mentions:TEXT OR hashtags:TEXT

The above would appear in Column B, and ideally all the text in Column A could be pasted into the " " section and the OR at_mentions:TEXT OR hashtags:TEXT part would automatically follow!

Thanks for any help!

Try

="""" &A1 &""""

will place A1 in quotes

Thanks for the quick response!

Sorry I couldn't make it clearer. I think the workbook is attached! Should help.

So in Column A we manually input the topic (in this case sports teams) In Column B, we want the team name in " " followed by at_mentions: OR hashtags:

The text following at_mentions: and hashtags: will be manually entered, but it would be cool to have the OR at_mentions: OR hashtags: part auto inputted!

Amazing! Thanks so much.

I have 1000's of entries to do, this saved me hours of work. Thanks to everyone who helped. I'm sure I'll be back to the forum for more solutions, answers and questions!