Insert single quote to multiple cells

tamien

New Member
Joined
Oct 9, 2002
Messages
2
I'm trying to insert automatically a single quote to the whole column which already has data in it. For example, the data in each cell of a column is CST100. I want it to be 'CST100'. I don't want to do it manually since there is about 1000 rows.

Thanks in advance.
tamie
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
On 2002-10-10 14:36, tamien wrote:
I'm trying to insert automatically a single quote to the whole column which already has data in it. For example, the data in each cell of a column is CST100. I want it to be 'CST100'. I don't want to do it manually since there is about 1000 rows.

Thanks in advance.
tamie
Hi tamie and welcome to the board.
Select the whole range,
In the active cell enter ''CST100'
Press on CTRL & ENTER simultaniously
and you'll get the desired data in all cells.

Eli
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
1. Insert a column to the right of your data, then, assuming your data starts in row 1 of column A, type this formula into cell B1:

="'"&A1&"'"

and copy down as far as is needed.

2. Select all the entries in column B, right click and choose Copy. Right click cell A1 and choose Paste Special, check Values and click OK.

3. Delete column B.
 

tamien

New Member
Joined
Oct 9, 2002
Messages
2
Thanks for your response. However, it's only half of what I want. Probably I didn't make it clear in my question.
For example, the data is below

CST100
CST200
CS9000
CY7000

and I want it becomes

'CST100'
'CST200'
'CS9000'
'CY7000'

So, if I do as your suggestion then the same data will be in each cell.

I hope it's clear now. Sorry. And thanks a lot.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

ADVERTISEMENT

I thought so - see my reply.
 

caprde74

New Member
Joined
Jun 11, 2014
Messages
1
1. Insert a column to the right of your data, then, assuming your data starts in row 1 of column A, type this formula into cell B1:

="'"&A1&"'"

and copy down as far as is needed.

2. Select all the entries in column B, right click and choose Copy. Right click cell A1 and choose Paste Special, check Values and click OK.

3. Delete column B.

Thank-you! this is exactly what I was looking for.
 

kiran25

New Member
Joined
Jun 13, 2014
Messages
1
I'm trying to insert automatically a single quote to the whole column which already has data in it. For example, the data in each cell of a column is CST100. I want it to be 'CST100'. I don't want to do it manually since there is about 1000 rows.

Thanks in advance.
tamie



=char(39) use this formula once to get single quotation
 

raknunna

New Member
Joined
Sep 9, 2014
Messages
1
1- select all the rows.
2- right click and select format cells
3- select number tab
4- select custom in the left category tab
5- under the type enter '@' ( if column has hello after applying format it will turn into 'hello').
as simple as that once you come to know this.
 

Forum statistics

Threads
1,144,310
Messages
5,723,640
Members
422,506
Latest member
mdindas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top