Quotation Marks in Excel

Shark 0 Reputation points


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

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,542 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Olaf Helper 41,411 Reputation points

    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 No comments

  2. Shark 0 Reputation points

    Thanks Olaf,

    I am trying to add a space between the 2 texts

    0 comments No comments

  3. Shark 0 Reputation points

    Problem solved. It was my keyboard setup apparently.


    0 comments No comments

  4. Emi Zhang-MSFT 22,556 Reputation points Microsoft Vendor


    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 No comments