ExcelBanter - find and replace

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find and replace (https://www.excelbanter.com/excel-discussion-misc-queries/233198-find-replace.html)

amik

find and replace

I have a column of this type of text

'29372
'23232

ect. I want to a find and replace to get rid of the ' what format
does it need to be in to do this.

Adam

Jacob Skaria

find and replace

Insert a column near to that and apply a formula; copy that down

=A1+0

If this post helps click Yes
---------------
Jacob Skaria

"amik" wrote:

I have a column of this type of text

'29372
'23232

ect. I want to a find and replace to get rid of the ' what format
does it need to be in to do this.

Adam

Shane Devenshire[_2_]

find and replace

Hi,

1. Select a blank cell and chooce Copy
2. Select all the cells you want to convert and choose Edit, Paste Special,
Add.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"amik" wrote:

I have a column of this type of text

'29372
'23232

ect. I want to a find and replace to get rid of the ' what format
does it need to be in to do this.

Adam

All times are GMT +1. The time now is 09:09 PM.