Excel: Trouble removing single quote before text 2

[althea]

I have a large list of data (some cells contain numbers and some contain text) and I cannot easily remove the single quote the import put in front of all text. Any suggestions?

 

[luceze]

The clean function will get rid of any non-printable characters.
Insert a column next to your data. In the first cell of the column corresponding with the start of your list enter this formula:

=clean(a1)

Where a1 is the first cell in your list.
Drag the formula down. Then copy\paste special\values to make the changes permanent.

HTH,
Eric

 

[SkipVought]

hi,
[tt]
=IF(ISERROR(VALUE(A1)),A1,VALUE(A1))
[/tt]
"removes" the [tic] from NUMERIC VALUES. Don't mess with alphanumeric text.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[luceze]

Skip,

Would you recommend this over the clean function?
If so, why?

Eric

 

[SkipVought]

Cuz' [tic] is not treated as an unprintable character.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[althea]

Thanks! It worked awesome!

 

[rss01]

Skip,

I'll give you a star for that. I was always saving the data as a text file, then resaving it back to excel.

Thanks

 

[SkipVought]

rss01,

What was the point of saving as text and then converting it back to Excel?

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[MeGustaXL]

Awesome Skip ==>*

Chris

Varium et mutabile semper Excel