Issue with Excel 2003

  • Thread starter Thread starter Good Intentions
  • Start date Start date
G

Good Intentions

I have found that when I import information into Excel 2003, Hyphens ar
not converted to a longer type symbol (almost like 2 hypen widths).
I've seen it in Microsoft Access 2003 also. How can I get hyphens t
remain as hyphens. For example, if I type a hyphen it shows up as -.
But here's a copy of what gets imported —. as you can see it's wider.
This gets annoying especially when I use Access and what to type i
something for a query. Can you help me
 
This response is from a newsgroup; your question has been (automatically) forwarded to here. I followed the link to your original
post at EXCELTIP.com and there indeed is a difference between the two hyphens. The long one is ASCII 151, the short one 45.
Sorry I can't help you any further

--
Kind regards,

Niek Otten


Niek Otten said:
<as you can see it's wider>

No. Both are ASCII 45
Click to expand...
 
You could use something like this in a macro that will convert them to long
hyphens

Selection.Replace What:=Chr(45), Replacement:=Chr(151), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Good Intentions"
 
Back
Top