VBA Insert spaces between each character...

slaycock · #1 07-02-2018, 03:46 PM

Depending on why you wish to add such spacing you might also consider the font spacing which might be easier to manage in the long term.

e.g. Try increasing the font spacing to 5 pt for a section of text. This gives the appearance of adding spaces between characters.

macropod · #2 07-02-2018, 04:00 PM

Quote:

Originally Posted by slaycock

This gives the appearance of adding spaces between characters.

It also has the advantage of not unnecessarily breaking words for line-wrapping purposes.

Chayes · #3 07-02-2018, 04:16 PM

Hi

Ok thanks for this. I find

Find = ^?
Replace = ^&^32

works fine. It inserts a hard space between each letter in a word , which is exactly what I was looking for.

Curiously , where a space exists say between two words in a phrase , it makes this into 3 spaces rather than the expected 2. Easily remedied with another search / replace , but I thought you'd like to know.

Thanks for your help - much appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert paragraph character after every 500 characters?	aditya_bokade	Word VBA	28	11-13-2021 10:48 PM
Find and Replace/Insert 'CR', delete leading Spaces wherever a user Clicks in a Word document	DavidL	Word VBA	7	04-04-2018 12:01 AM
Detecting that previous character doesn't exist (i.e., present character is first in document)	Robert K S	Word VBA	15	08-01-2016 09:33 AM
macro to find a character and insert space so autocorrect will expand	redzan	Word VBA	3	05-22-2014 04:22 PM
Office 2010 - insert character after each line.	Ernst-Emil	Word	7	08-15-2012 09:13 AM