Share via

Quotation Marks in Excel

Shark 0 Reputation points
2023-10-10T06:35:02.34+00:00

Hello

I am trying to add a space between two TEXTS: A1 & B1.

So in the formula bar I write: = (A1&'' ''&B1). Unfortunately it does not work.

I have also tried = (A1&' '&B1).

Can you please help me in using quotation marks in Excel. I am a windows users.

Thank you

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,246 Reputation points
    2023-10-10T06:40:32+00:00

    I am trying to add a space between two ... using quotation marks

    Your post is very unclear; what do you want to add to the text, a space or quotation mark?

    If it's the quotation mark, then you have to quote = double it =>

    = A1 & """" & B1
    0 comments
  2. Shark 0 Reputation points
    2023-10-10T06:43:35+00:00

    Thanks Olaf,

    I am trying to add a space between the 2 texts

    0 comments
  3. Shark 0 Reputation points
    2023-10-10T07:02:27.6033333+00:00

    Problem solved. It was my keyboard setup apparently.

    Thanks

    0 comments
  4. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2023-10-10T07:19:22.31+00:00

    Hi,

    You can try this formula

    =A1&" "&B1

    User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    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.

    0 comments