Help with excel formatting (change data info)

Associate
Joined
19 Oct 2002
Posts
804
Location
Leicester
Im trying to edit an speed camera POI file so i can use with a program on my N95 mobile.

It needs to be in the following format
Code:
GATSO@40
GATSO
MOBILE@60
TRUVELO@0
RedLight@30
SPECS@70

But what i have is (as an example)

Code:
GATSO:1@64
GATSO:10@80
GATSO:1000@48
GATSO:1001@48
GATSO:1003@48
GATSO:1004@48

I need to remove the numbers between the GATSO and the @

I have uploaded the file im messing around with herehttp://www.starcote.co.uk/kk.csv
 
Back
Top Bottom