Would like this function to be made to work like a MID function, but in reverse.
Posted on 2016-10-27
I have a number of cells like this:
a2= Text to Columns - Data > Data Tools > Text to Columns
The number of dashes vary before the > symbol, but I always want to pull the data from the end of the cell up to the dash.
The function would work like this: FromEnd("-",a2) and it would return
- Data > Data Tools > Text to Columns
I could then use Mid to select after the dash.
Function Reverse(str As String) As String
Reverse = StrReverse(Trim(str))