Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of songs, but the name of the song and artist are all in the
same cell. I'd like to be able to sort by artist. Is there a formula that I could enter in B1 ,B2 , etc. that could text everything starting with the 3rd character to the right of each dash (-) ? (A1) Earth Angel - The Penguins (A2) El Paso - Marty Robbins so that the B column result would be The Penguins Marty Robbins Note: The 13 characters in these samples are obviously just a coincidence, and other cells will have different number of characters. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Need insert a dash in between last 4 digits in text string | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |