Characters

[tmiller1]

I have a column of numbers and want to do a concatenate to place ' ' , around it so it looks like
'1111111', for example. I tried the following:

column1 column2 column3 column4
111111 ' ', =concatenate(b2,a2,c2)


However, the ' in column2 and the ' beginning in column3 do not appear. How can I make them appear? I have tried text, general and nothing.

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[nomwich]

I know in concatenate, you can use double quotation marks (" ")to append any string of text you'd like to a cell. For instance, =CONCATENATE("'",A2,"'") will add a single quote to the start and end of whatever is contained in A2. In this case, '111111'.

You could also switch the single quote ('), to the single quote contained on the Tilde key (`). That does display without any problems. To make a single quote appear, you have to enter two single quotes(''). I don't know why that is.