Thread: [Solved] Text manipulation in MACRO
View Single Post
 
Old 03-10-2013, 06:26 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes. I run the macro against that and it outputs:

AN TMA LORRAINE partie 5
AC D
AH FL075
AL 4000ft AMSL
49º09’22”N,006º49’12”E -- **French border**
49º09’04”N,006º50’02”E -- 49º02’02”N,006º59’35”E --
49º01’06”N,006º57’56”E -- arc horaire de 10NM de
rayon centré sur 48º59’11”N,006º42’58”E (GTQ) --
48º57’22”N,006º57’57”E -- 48º53’58”N,007º04’08”E --
48º46’19”N,006º54’21”E -- 48º49’46”N,006º48’06”E --
arc horaire de 10NM de rayon centré sur
48º59’11”N,006º42’58”E (GTQ) --
48º49’12”N,006º42’05”E -- 48º47’54”N,006º39’37”E --
49º08’00”N,006º34’45”E -- 49º08’00”N,006º45’20”E --
49º09’07”N,006º44’42”E -- arc horaire de 10NM de
rayon centré sur 48º59’11”N,006º42’58”E (GTQ) --
49º08’39”N,006º47’55”E -- 49º09’22”N,006º49’12”E
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote