Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
text to the left and right of
2 views
Skip to first unread message
Esra
Jan 28, 2008, 3:46:29 AM1/28/08
to
I have a list of file names (Music), the format is "Beatles - Yellow
Submarine" in cells a1 to a10000 (for arguments sake). I want to have
in B1 - Beatles and in C1 - Yellow Submarine.
Submarine" in cells a1 to a10000 (for arguments sake). I want to have
in B1 - Beatles and in C1 - Yellow Submarine.
All files are the same format (Beatles - Yellow Submarine.mp3)
What formulas would I use to get the text to the left of "-" and text
to the right of "-"? Any helpers greatly appreciated
Esra
0 new messages