inserting space

[usamampk]

please i need kind help

i have data in symbols in a cell. need to insert space after every symbol in a single cell, as

ہسیصنط


ہ س ی ص ن ط

the sample file is attached
please help

[Joske920]

Hi
I wrote a little function so you can use it as a formula
in order to use it in you workbook you will need to add the code in a module in the VBE

Please Login or Register  to view this content.

use the formula as '=SpaceOut(D6)

[wk9128]

F6 cell , array formula

[Rick Rothstein]

I don't deal with international programming, so I cannot be 100% sure, but I believe this one-liner function (named the same as Joske920's function) will do the same thing as Joske920's function does...

Please Login or Register  to view this content.

Edit Note: I don't have Excel 365, but I see wk9128 who does have it has posted a straight Excel formula that he believes works.

[usamampk]

Thanks for the great help provided. problem solved

[wk9128]

Wow, your custom function can be expressed in one line, which is great, I learned from you @Rick Rothstein

PS : In fact, my custom function TEXTJOIN uses OFFICE2007 to solve the high version OFFICE2019 exactly the same function, and I don’t have the OFFICE2019 version.

My custom function is so long

Function zk(x As Range)
y = Len(x)
For i = 1 To y
zk = zk & Mid(x, i, 1) & " "
Next i
zk = Left(zk, Len(zk) - 1)
End Function