insert a space every x characters Solved

Question

Hello,
I would like to know if it's possible with a macro to insert a space every 4 characters in a string of text:

FR7613825002000877044273408

the desired result:
FR76 1382 5002 0008 7704 4273 408

for all selected cells

thank you in advance

Configuration: Windows 7 / Internet Explorer 9.0

navigo · Accepted Answer

=LEFT(A1,4)&" "&MID(A1,5,4)&" "&MID(A1,9,4) etc.

ccm81 · Answer

Hello

And if you want a macro at all costs

Public Function insespace(s As String, n As Long) As String
If n = 0 Or s = "" Then insespace = "error": Exit Function
If Len(s) <= n Then
 insespace = s
Else
 insespace = Left(s, n) & " " & insespace(Right(s, Len(s) - n), n)
End If
End Function

Best regards

lapprenti2 · Answer

Hello and thank you all  it's great when it works.....  have a good end of the day

Insert a space every x characters

3 réponses

Usb firmware search for continental edison celed43sauhd23

Convert ntfs to exfat without data loss

On my samsung galaxy s20 - virus message

Connect dvd player hdmi to usb port

Call forwarding with free

Olympus s922 dictaphone

Access to a shared mailbox for multiple users

Transformer output drawing + and -

Big problem with dell inspiron 5640d black screen flashing bios

Bluetooth, receiving multiple images on your pc (one by one)