Brad_Miller
Board Regular
- Joined
- Sep 18, 2014
- Messages
- 56
Hi Excel geniuses
I am trying to sort my movies I have and I have them listed with a marker at the end of the file either [720p] or [1080p] or nothing
I have used these formulas to move the resolution tag to the front so I can group movies by resolution.
I used these serpeatly to move the tag but I get so loast trying to make them a nested if
=IF(SEARCH("[720p]",A1),CONCATENATE(RIGHT(A1,0),"[720p] ", LEFT(A1,FIND("[720p]",A1,1)-1)))
=IF(SEARCH("[1080p]",A9),CONCATENATE(RIGHT(A9,0),"[1080p] ", LEFT(A9,FIND("[1080p]",A9,1)-1)))
AND!
Ideally i would like to have one formula that move both tag and then if there is no tag leave it as is.
<tbody>
</tbody>
<tbody>
</tbody>
Thanks in advance!
I am trying to sort my movies I have and I have them listed with a marker at the end of the file either [720p] or [1080p] or nothing
I have used these formulas to move the resolution tag to the front so I can group movies by resolution.
I used these serpeatly to move the tag but I get so loast trying to make them a nested if
=IF(SEARCH("[720p]",A1),CONCATENATE(RIGHT(A1,0),"[720p] ", LEFT(A1,FIND("[720p]",A1,1)-1)))
=IF(SEARCH("[1080p]",A9),CONCATENATE(RIGHT(A9,0),"[1080p] ", LEFT(A9,FIND("[1080p]",A9,1)-1)))
AND!
Ideally i would like to have one formula that move both tag and then if there is no tag leave it as is.
Original Name | modified Name |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Thanks in advance!
Last edited: