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"
<Good.Intentions.261vnm_1144675502.9036@excelfor um-nospam.com wrote in
message news:Good.Intentions.261vnm_1144675502.9036@excelf orum-nospam.com...
I have found that when I import information into Excel 2003, Hyphens are
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 to
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 in
something for a query. Can you help me?
--
Good Intentions
------------------------------------------------------------------------
Good Intentions's Profile:
http://www.excelforum.com/member.php...o&userid=33330
View this thread: http://www.excelforum.com/showthread...hreadid=531508