Add Function to String
 

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.

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.

"Ronbo" wrote:

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

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

"Ronbo" wrote in message
...
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.

"Ronbo" wrote:

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.