COLUMN A | COUMN B |
TX-ABC-12345 | TX-ABC-123-45 |
TX-AB-135690 | TX-AB-135-690 |
PP-BC-1234 | PP-BC-123-4 |
AB-DEF-01 | AB-DEF-01 |
AB-DEF | AB-DE-F |
<tbody>
</tbody>
I have a data as above in column A. I want the target data as column B.
My requirement is to count the number of characters after last hyphen. If the characters are >=4 then add a hyphen after 3 characters and display the total string.
please help me with a formula.