help commas before data

Ok, i have these tick marks (they're comma's) in every cell before my data,
for example '27458, '33354

I can't get a vlookup to work unless i get rid of the comma's. the problem
is i have 28000 rows to fix. Any ideas?

I'm using Excel 2000.

TIA

James

sorry, i meant apostrophes
"James" <[email protected]> wrote in message
news:[email protected]...
> Ok, i have these tick marks (they're comma's) in every cell before my
data,
> for example '27458, '33354
>
> I can't get a vlookup to work unless i get rid of the comma's. the problem
> is i have 28000 rows to fix. Any ideas?
>
> I'm using Excel 2000.
>
> TIA
>
> James
>
>

check out the CLEAN() function in Excel help.

"James" wrote:

> sorry, i meant apostrophes
> "James" <[email protected]> wrote in message
> news:[email protected]...
> > Ok, i have these tick marks (they're comma's) in every cell before my
> data,
> > for example '27458, '33354
> >
> > I can't get a vlookup to work unless i get rid of the comma's. the problem
> > is i have 28000 rows to fix. Any ideas?
> >
> > I'm using Excel 2000.
> >
> > TIA
> >
> > James
> >
> >
>
>
>

Use the 'Data', 'Text-to-column' feature. It'll do it in one operation.
--
HansM

"James" <[email protected]> wrote in message
news:[email protected]...
> sorry, i meant apostrophes
> "James" <[email protected]> wrote in message
> news:[email protected]...
>> Ok, i have these tick marks (they're comma's) in every cell before my
> data,
>> for example '27458, '33354
>>
>> I can't get a vlookup to work unless i get rid of the comma's. the
>> problem
>> is i have 28000 rows to fix. Any ideas?
>>
>> I'm using Excel 2000.
>>
>> TIA
>>
>> James
>>
>>
>
>

James wrote:
|| Ok, i have these tick marks (they're comma's) in every cell before
|| my data, for example '27458, '33354
||
|| I can't get a vlookup to work unless i get rid of the comma's. the
|| problem is i have 28000 rows to fix. Any ideas?
||
|| I'm using Excel 2000.
||
|| TIA
||
|| James

Find ' replace "nothing" (and I mean nothing - leave the Replace field
blank)

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

use the 'copy' then 'values only' for the entire column after you have
cleaned the column

"Gate" wrote:

> check out the CLEAN() function in Excel help.
>
> "James" wrote:
>
> > sorry, i meant apostrophes
> > "James" <[email protected]> wrote in message
> > news:[email protected]...
> > > Ok, i have these tick marks (they're comma's) in every cell before my
> > data,
> > > for example '27458, '33354
> > >
> > > I can't get a vlookup to work unless i get rid of the comma's. the problem
> > > is i have 28000 rows to fix. Any ideas?
> > >
> > > I'm using Excel 2000.
> > >
> > > TIA
> > >
> > > James
> > >
> > >
> >
> >
> >