Quotation Marks in Excel

Question

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

Answer 1

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

Answer 2

Thanks Olaf,

I am trying to add a space between the 2 texts

Answer 3

Problem solved. It was my keyboard setup apparently.

Thanks

Answer 4

Hi,

You can try this formula

=A1&" "&B1

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.