Insert Charters into a number string vba or formula?

[irrefutable14]

I'd like to update a string of numbers and add charters before each string of numbers. IE

[TABLE="width: 500"]
<tbody>[TR]
[TD]006-01-00-00
[/TD]
[TD]R006-B01-S00-P00
[/TD]
[/TR]
[TR]
[TD]006-01-01-00
[/TD]
[TD]R006-B01-S01-P00
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

If your inputs are always text strings in exactly the format 000-00-00-00 and the characters to be inserted are always R, B, S, P in exactly those positions, then you can do it like this

="R"&left(a1,4)&"B"&mid(a1,5,3)...and so on.

If there is more variety to your situation, you'll need something more complicated.