redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
I was given this formula that will reproduce all the data after the '-' symbol
so on this example:
SC2272-02 - Little River Band, The - Lonesome Loser
with the above formula, this is the result
Lonesome Loser
Can the code be adjusted so that everything after the FIRST '-' is displayed, so with athe above example the result would actualy be:
Little River Band, The - Lonesome Loser
any help appreciated
thanks
I was given this formula that will reproduce all the data after the '-' symbol
Code:
=TRIM(REPLACE(C785,1,LOOKUP(2^15,FIND("-","-"&C785,ROW(INDIRECT("1:"&LEN(C785)))))-1,""))
so on this example:
SC2272-02 - Little River Band, The - Lonesome Loser
with the above formula, this is the result
Lonesome Loser
Can the code be adjusted so that everything after the FIRST '-' is displayed, so with athe above example the result would actualy be:
Little River Band, The - Lonesome Loser
any help appreciated
thanks