Prev: [discuss] FOTO DE NÓS 2 JUNTOS!!!
Next: [discuss] Instalar OpenOffice 2.4
From: g.rowe on 16 Apr 2008 05:41
If you need to remove the leading apostrophe (leading ') from cell
contents you'll find that the normal Find and Replace function does
not work as expected if you just search on '. You may run into this
problem if you download XLS spreadsheets from sites that want to
preserve formatting by tricking Excel into using text rather than
relying on it's dubious conversion rules (Betfair is one example).

To remove this formatting trick, use the following configuration and
it'll just work:

1) Enter a single period into ''Search For' (eg .)
2) Enter a single ampersand into 'Replace With' (eg &)
3) Select 'More Options'
4) Tick the Regular Expression checkbox
5) Click 'Replace All'

This will convert all cells that contain a leading ' to their native
format, eg numeric, date etc

Hope this tip helps someone else out, it bugged me for a long time.

Cheers,

Gary
 | 
Pages: 1
Prev: [discuss] FOTO DE NÓS 2 JUNTOS!!!
Next: [discuss] Instalar OpenOffice 2.4