Hi, I have thousands of entries in my music catalogue. Some are entered as example Cell A1 contains, ""Hello - Adelle"".
How do I remove from the "-" (Adelle), and place in cell B2 and then delete the extracted part from cell A1?
Thanks for any help,
Hi
Do you want something like this
starting from A2 in b2 copied down
Regards
Please Login or Register to view this content.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
Thanks, but that only removes part of the cell data required.Originally Posted by mahju
Hi
Do you want something like this
starting from A2 in b2 copied down
RegardsPlease Login or Register to view this content.
Enter formula in B1 and pull it to to the right
Formula:
Please Login or Register to view this content.
v A B C 1 Hello - Adelle Hello Adelle
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks