Make formula changes but save the results as text in the same cell

Richard Ehlers 20 Reputation points
2023-03-15T05:05:53.7133333+00:00

I have a list of entries that I want to convert to be surrounded by double quotes (")

The content of these entries can then be used to apply to formulas further used in the book I am working with.

To perform the quote addition, the only way I can think of is to generate a new column, use CONCATENATE("""",(REF),"""") and save as a csv. Reload the csv and delete the column that does not have the quotes.

I was hoping there was a command that would enable me to achieve this without exiting as doing so also only saves the sheet I am working on and not the book.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,431 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,450 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,521 Reputation points
    2023-03-15T08:08:00.3866667+00:00

    Hi @Richard Ehlers

    You may try the Format Cell.

    • Select and right-click the data > Format Cell > Custom > Enter "''"@"''" into the Type textbox.

    Capture41

    If the steps does not meet your request, you may need the help of VBA code or 3rd-party add-in.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful