J
John Dough
I have the following which I highlighted and copied from a TextEdit file:
-Bedouin poets
-Altar in women's chapel
-soldier (and workers) at earthquake damage
-Chapel Latin Mission (image in painting only)
-Chapel w 2 altars (images in paintings only)
-Crowned Statue (bust)
-Damascus Gate (seperates of 3 nearest people)
-Ecca Homo Arch (close up of woman)
-Herod's Gate (man in left side)
-Lion's Gate (person w donkey)
-Mary's Well (women w urns)
-Mosque Interior (stairs & door only)
-Phillip's Spring (woman)
-Shrine of the Sun (seperates of individuals, include camel)
-Via Doloraos (couple walking toward camera)
When I copy and past it into Excel I get the following:
#NAME?
-Altar in women's chapel
#NAME?
#NAME?
-Chapel w 2 altars (images in paintings only)
#NAME?
-Damascus Gate (seperates of 3 nearest people)
#NAME?
-Herod's Gate (man in left side)
-Lion's Gate (person w donkey)
-Mary's Well (women w urns)
-Mosque Interior (stairs & door only)
-Phillip's Spring (woman)
#NAME?
#NAME?
Also, if I try to use Past Special when I initially paste into Excel, I do
not get the usual choices (values, formats, etc) but only get an unfamiliar
dialog box that lists Source with a radio button "Paste" as the only choice,
and a sub box that says "As", with the only choice "Text" available. It
doesn't help.
It looks like it is interpreting the hyphen as some sort of formula, but why
in some rows and not in others?
I thought I would try to clean it up using the Len and Right functions, but
when I ran the Len function on the first row it returned 2.
Can someone explain to me what in #$%^^& is going on here. This is really
awful and someone at Microsoft should address this kind of program behavior!
-Bedouin poets
-Altar in women's chapel
-soldier (and workers) at earthquake damage
-Chapel Latin Mission (image in painting only)
-Chapel w 2 altars (images in paintings only)
-Crowned Statue (bust)
-Damascus Gate (seperates of 3 nearest people)
-Ecca Homo Arch (close up of woman)
-Herod's Gate (man in left side)
-Lion's Gate (person w donkey)
-Mary's Well (women w urns)
-Mosque Interior (stairs & door only)
-Phillip's Spring (woman)
-Shrine of the Sun (seperates of individuals, include camel)
-Via Doloraos (couple walking toward camera)
When I copy and past it into Excel I get the following:
#NAME?
-Altar in women's chapel
#NAME?
#NAME?
-Chapel w 2 altars (images in paintings only)
#NAME?
-Damascus Gate (seperates of 3 nearest people)
#NAME?
-Herod's Gate (man in left side)
-Lion's Gate (person w donkey)
-Mary's Well (women w urns)
-Mosque Interior (stairs & door only)
-Phillip's Spring (woman)
#NAME?
#NAME?
Also, if I try to use Past Special when I initially paste into Excel, I do
not get the usual choices (values, formats, etc) but only get an unfamiliar
dialog box that lists Source with a radio button "Paste" as the only choice,
and a sub box that says "As", with the only choice "Text" available. It
doesn't help.
It looks like it is interpreting the hyphen as some sort of formula, but why
in some rows and not in others?
I thought I would try to clean it up using the Len and Right functions, but
when I ran the Len function on the first row it returned 2.
Can someone explain to me what in #$%^^& is going on here. This is really
awful and someone at Microsoft should address this kind of program behavior!