- Oct 31, 2008
I have a cell that has text with a dash in the middle (xxxx-xxxxA). Sometimes there are 4 characters and sometimes there are 5. I would like to take all the text to the right of the dash regardless of the number of characters and place that into another cell. If I use the right(A1,5) formula, it works for one with 5 charachters, but for one with 4 it also takes the dash. What can use formula wise to achieve this?