Ask Your Question

custom format text with spaces

asked 2019-07-28 00:49:37 +0200

dejayajay gravatar image

updated 2020-08-07 19:54:12 +0200

Alex Kemp gravatar image

How do I format text to appear with a space after each four characters, as in abcd efgh ijkl mnop (etc). Or with mixed alpha-numerics AB12 3456 CD78?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-28 08:00:15 +0200

There is no format code available to change representation of text (apart from ability to prepend/append some static text; see "Text and Text" there).

So if you want that, you'd need some formula cell that would actually change the string - like this formula using new REGEX function from version 6.2:

=REGEX(A1;"....(?!$)";"$0 ";"g")
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-28 00:49:37 +0200

Seen: 68 times

Last updated: Jul 28 '19