Converting a string of text into a custom format.

[archilles89]

Hi,

I have a string of characters which starts from random numbers and ends with a letter.

I want to add a "-" into every string right before the letter. For example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]String[/TD]
[TD="align: center"]Wanted Result[/TD]
[/TR]
[TR]
[TD="align: center"]51313202041A[/TD]
[TD="align: center"]51313202041-A[/TD]
[/TR]
[TR]
[TD="align: center"]000035140B[/TD]
[TD="align: center"]000035140-B[/TD]
[/TR]
[TR]
[TD="align: center"]9482939498c[/TD]
[TD="align: center"]9482939498-c[/TD]
[/TR]
</tbody>[/TABLE]

Any help is tremendously appreciated. Thanks!

 

[Rick Rothstein]

It is not clear what kind of solution that you are after... would a formula solution be acceptable?

=REPLACE(A1,LEN(A1),0,"-")