Insert single quote to multiple cells

[tamien]

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

 

[eliW]

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]

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]

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]

I thought so - see my reply.

 

[caprde74]

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]

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]

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.