Re: Importing from other application

Hi Reggie

the reason it did this is that you could of had a comma separated file,
which would normally split entries up by using a comma, but as you've got a
comma in the number it put the "" around it to indicate not to split it up
(did that make any sense)
anyway to fix
select your workbook
choose
edit / replace
type a " in the first box
leave the replace with box blank
click Replace all

(note, it's always a good idea to try things like this out on a copy of the
workbook first, just in case)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Reggie" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:177501c536d6$ab15efd0$a601280a@xxxxxxxxxx
> Hello!
>
> When I brought in some data recently, I noticed that one
> of my fields came in in quotes (ex: "7,125") for some
> reason. And not everything in that field was like that -
> only the numbers greater than 1,000. Weird, huh?!?
>
> Anyway, is there a way in which I can remove these quotes
> without going through all 10,174 lines in my database and
> doing it manually?
>
> Thanks for any assistance!
>
> Reg


.

Relevant Pages

  • Re: Importing from other application
    ... replace part of a cell without replacing the whole cell. ... >the reason it did this is that you could of had a comma ... >which would normally split entries up by using a comma, ... >workbook first, just in case) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: can Roger take Del Potro?
    ... years completed means you completed the fourth year of your life. ... If you think about it - there is no real reason save societal norms to ... However after learning that actually dot is the one used in SI system, the international system...I have lately began to use dot in these international forums(well it took me looooong time to accept that I had been kind of wrong using the comma) ...
    (rec.sport.tennis)
  • Re: NFS syntax error in /etc/fstab?
    ... Mark J. Reed became daring and sent these 0.4K bytes, ... > For some reason, if I type ... no comma, i.e.: ... /\/ GnuPG key fingerprint is in the header ...
    (Fedora)
  • Re: Alternate phrase for "The problem is"
    ... dash off the comma after it, and launch into the real, the selfish ... reason why they're talking to you at all. ...
    (alt.usage.english)
  • Re: c symbols with different meanings in different contexts
    ... int a=1,b; ... so one makes comma act as a initializer list separator and the other ... so what may be actual reason for generation of the error... ... therefore as an assignment expression. ...
    (comp.lang.c)