Add Function to String

[Ronbo]

I am looking for a function or (way) to add characters to a text string. It
would be like the replace function in that, I know the position of the text
to be added.

Example: Text in cell A1 = Widget12

I would like to create a routine that has a function or (way) to change this
(A1) to
Widget 12.

 

[Ronbo]

Ok - I got how to do it in the example, REPLACE(a1,7,," ") but I have a lot
of spaces that need to be added... so the question is how do I continue?

I tried REPLACE(a1,7,," "),REPLACE(a1,10,," ") etc. but I am not getting it
to work. Again and as always, thanks for any help.

 

[Steve]

Ronbo

Some additional information on the format might help:

Example: If always two numbers on the end this should work:
=REPLACE(A1,LEN(A1)-1,," "))


Steve