vba find numbers in document and align text left

macropod · #1 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.

peligroso · #2 09-15-2015, 05:27 AM

Quote:

Originally Posted by macropod

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.

Thanks, I will try those methods and see how well they work.

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