Hello,
I've got a question about a long list of music tracks I want to import in Spotify (before doing that I have to edit the list a bit in Excel), unfortunately partly having an apostrophe at the beginning of the line for some reason.
How do I remove those aposthrophes at the beginning, while keeping the others (not manual, but with a formula)?
I've tried this formula: =RIGHT(A2,LEN(A2)-FIND("#",SUBSTITUTE(A2,"'","#",1)))
But this is the result:
i.ibb.co/P50Q8yy/excel.png
How can I manipulate that formula, to get the complete list in the 'B' column, instead of getting all those #VALUE! (#WAARDE! in The Netherlands; I'm Dutch) stuff?
Thanks already.
Bookmarks