nffcspw
New Member
Members
Forum Posts: 2
Member Since:
December 22, 2016
December 22, 2016
Offline
I have a column with 10000+ rows containing text. The text follows a naming convention of TEXT - TEXT - TEXT. I want to check for all rows where there are no spaces before and after each instance of "-" . For example "Text- Text - Text", "Text -Text - Text" and "Text - Text- Text" etc should all be highlighted as errors. Each text string includes letters and numbers and can have between 1 and 5 instances of "-" in each. I have tried various options in the regular find/replace tool including wildcards without success. I'm guessing I'll have to go down the VBA route but I can't figure out how. Can anyone advise please?
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Kathleen Silva, Alex Dawson, Kang-Ting Lee, Karla de Visser
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33706
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —