stuartgb100
Active Member
- Joined
- May 10, 2015
- Messages
- 322
- Office Version
- 2021
- Platform
- Windows
Hi, I have approx 5,000 rows of data that need attention. Data is in col E and looks like this: | |||||
Volume serial number is 349F-83B7
H:.
output.doc
\---NAS Archive (Music - Artists 1)
+---10cc
+---20th Century Masters The Millennium Collection Best Of 10CC
01_Life Is A Minestrone.flac
02_Channel Swimmer.flac
02_Channel Swimmer.lrc
03_I'm Not In Love.flac
03_I'm Not In Love.lrc
I'd like a vba script that will :
a) act on col E in single worksheet
b) if the data starts with \---, then remove those characters and delete the three cells to the left
c) if the data starts with +---, then remove those characters and delete the two cells to the left
d) if the data ends with .Irc, then delete the entire row
Any help much appreciated.
Many thanks