Wolksby Posted November 25, 2021 Share Posted November 25, 2021 Hi, I have a very simple question, the answer to which should save me some time, but I don't want to push blindly ahead, and then find I've screwed up! In the Title field, I show the title of the piece of music, and then, using the Convert function, which I learnt from another forum here, I was able to show that original title, and then have the composer's name automatically added afterwards in brackets. Originally it would show: 'Nocturne in C minor' (the composer in the composer's column would show Chopin, Frederick. Using Convert, the title would then show as Nocturne in C minor [Chopin, Frederick} Just suppose I had spelt Chopin in correctly, say Shopin. It would be easy to change all the instances in the Composer colun from Shopin, Frederick to Chopin, Frederick. But this DOESNT alter the composer's name appended to the title, so that will still show incorrectly. If I just select everything and do the Convert again, while it takes the information from the corrected composer's name, it doesn't delete the original entry! So I'd end up with Nocturne in C minor [Shopin, Frederick] [Chopin, Frederick What I' like to be able to do is to take the Composer column in bulk, and do what on Word would be Find and Replace, or similar, I would ask it to find all the instances of Shopin, and ask that these be changed to Chopin - of ask it to find all Shopin, Fredericks and bulk change these inot Chopin, Frederick. It must be easy, but I'm always afriad of screwing up, even with a couple of backups! Many thanks! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.