[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]COLUMN A
[/TD]
[TD]COUMN B
[/TD]
[/TR]
[TR]
[TD]TX-ABC-12345
[/TD]
[TD]TX-ABC-123-45
[/TD]
[/TR]
[TR]
[TD]TX-AB-135690
[/TD]
[TD]TX-AB-135-690
[/TD]
[/TR]
[TR]
[TD]PP-BC-1234
[/TD]
[TD]PP-BC-123-4
[/TD]
[/TR]
[TR]
[TD]AB-DEF-01
[/TD]
[TD]AB-DEF-01
[/TD]
[/TR]
[TR]
[TD]AB-DEF
[/TD]
[TD]AB-DE-F
[/TD]
[/TR]
</tbody>[/TABLE]
hi forum members,
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.
<tbody>[TR]
[TD]COLUMN A
[/TD]
[TD]COUMN B
[/TD]
[/TR]
[TR]
[TD]TX-ABC-12345
[/TD]
[TD]TX-ABC-123-45
[/TD]
[/TR]
[TR]
[TD]TX-AB-135690
[/TD]
[TD]TX-AB-135-690
[/TD]
[/TR]
[TR]
[TD]PP-BC-1234
[/TD]
[TD]PP-BC-123-4
[/TD]
[/TR]
[TR]
[TD]AB-DEF-01
[/TD]
[TD]AB-DEF-01
[/TD]
[/TR]
[TR]
[TD]AB-DEF
[/TD]
[TD]AB-DE-F
[/TD]
[/TR]
</tbody>[/TABLE]
hi forum members,
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.