vba find numbers in document and align text left

macropod · #5 09-14-2015, 10:31 PM

Quote:

Originally Posted by Guessed

FWIW, I think the leading spaces is normal behaviour with Excel content pasted into Word depending on the cell formatting applied in Excel.

When I paste an Excel range containing both text numeric data into Word, the data retain the same formatting and alignments they had in Excel and there are no leading/trailing spaces. In this regard, I note the OP is just using an ordinary Paste, not Word's PasteExcelTable or PasteAndFormat methods, for example.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to either move document display to right or left; or reduce size of find/replace window.	pmstock	Word	2	08-02-2014 08:34 PM
Find and Replace function shooting off screen to the left of the document	Mattblack	Word	1	04-10-2014 03:06 PM
Align...both left and right?	supersimu	Word	1	01-25-2014 02:05 AM
Numbers on the left side of the text	Felipe	Word	2	04-19-2012 07:35 AM
How to align page to left side instead of centre	ghumdinger	Word	2	08-18-2011 10:15 AM