How to add spaces to text?

Hello Friends

From input cell A1 text, Need the space removed text in B1 by using formula.

thanks in advance

What you have shown in your attachment is the opposite of what you are asking, so please clarify: do you want the spaces adding or removing?

This will REMOVE spaces:

=SUBSTITUTE(A1," ","")

Hello Ali

Thanks for your formula. I have made a mistake here, my requirement is just reverse. So i am closing this thread and opened a new thread.

https://www.excelforum.com/excel-for...ml#post4807552

thanks again.

Continue here, please. I have amended the title of the opening post. You know the rules about thread duplication - it is NOT allowed.

Hello gondal

Thanks form your UDF which is working well.

But please confirm for UDF whether we need to save the file in .xlsm format or .xlsx is sufficient.

If you don't save as .xlsm, when you close and re-open the file, you will lose the UDF.