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.