String formatting in Excel

Question

I have a simple query.

How can I format the text in cells in my Workbook.

If my cell has text ABC, I want it in the format 'ABC'. Is there any formula for this?

I am using Excel 2010. I cannot do find and replace as all the values I want to alter are unique

Igor Pejic · Accepted Answer · 2020-07-23 10:55:48Z

4

@ represents your text

answered Jul 23, 2014 at 10:45

Igor Pejic

3,7061 gold badge17 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rare information! Relearned this from a few years ago! Hard to find on the web.

Donal · Accepted Answer · 2014-07-23 10:44:47Z

2

Use CONCATENATE. For example if the cell is A1 then the function would be:

=CONCATENATE("'", A1, "'")

answered Jul 23, 2014 at 10:44

Donal

33.2k10 gold badges69 silver badges75 bronze badges

Sunny Sharma · Accepted Answer · 2014-07-23 11:17:44Z

0

Just to add value to lgor's answer as He's already made the point.

"@" represents the text.

Just go to format cells > custom and surround the @ with two Apostrophes, like: '@' and it will work.

answered Jul 23, 2014 at 11:17

Sunny Sharma

5,0045 gold badges41 silver badges76 bronze badges