How to remove indent in table cell from Excel

I copied part of an XLS spreadsheet to create a Word table. The text in many
cells is indented in the original, but I need to make these flush left within
the cell. But I can't find a place within Word where this indent is shown:
it's not in the table cell specs nor in the paragraph definition. Is there a
way to unindent?

My purpose is to do this within VBA, in case that changes the answer.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200911/1

Dim i As Long, j As Long
With ActiveDocument.Tables(1)
For i = 1 To .Rows.Count
For j = 1 To .Columns.Count
.Cell(i, j).LeftPadding = 0
Next j
Next i
End With


--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"christophercbrewster via OfficeKB.com" u3143@uwe wrote in message
news:9fa96d97b886a@uwe...
I copied part of an XLS spreadsheet to create a Word table. The text in
many
cells is indented in the original, but I need to make these flush left
within
the cell. But I can't find a place within Word where this indent is shown:
it's not in the table cell specs nor in the paragraph definition. Is there
a
way to unindent?

My purpose is to do this within VBA, in case that changes the answer.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200911/1

Thanks, but that doesn't get rid of the inherited indents-- it only gets rid
of the cell padding. As I said, I was unable to get rid of the indents using
the Table Properties dialog. Something in the text from Excel carries an
indent with it, but I can't find any way that it's defined within Word. If
you make a test worksheet in Excel and use the indent button on a few cells
(use different indents in different cells to make it conspcuous), then import
it to Word, I think you'll see the effect I mean.

Doug Robbins - Word MVP wrote:
Dim i As Long, j As Long
With ActiveDocument.Tables(1)
For i = 1 To .Rows.Count
For j = 1 To .Columns.Count
.Cell(i, j).LeftPadding = 0
Next j
Next i
End With

I copied part of an XLS spreadsheet to create a Word table. The text in
many
[quoted text clipped - 6 lines]

My purpose is to do this within VBA, in case that changes the answer.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200911/1

I found the specification that applies. It's in Format Paragraph, under
Indentation: the "Special" box says "1st Line" or "Hanging". This is what
needs to be 0.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200911/1

Try selecting the cells and reapply the Style.

--
Terry Farrell - MSWord MVP

"christophercbrewster via OfficeKB.com" u3143@uwe wrote in message
news:9fe4bddf7ce8b@uwe...
Thanks, but that doesn't get rid of the inherited indents-- it only gets
rid
of the cell padding. As I said, I was unable to get rid of the indents
using
the Table Properties dialog. Something in the text from Excel carries an
indent with it, but I can't find any way that it's defined within Word. If
you make a test worksheet in Excel and use the indent button on a few
cells
(use different indents in different cells to make it conspcuous), then
import
it to Word, I think you'll see the effect I mean.

Doug Robbins - Word MVP wrote:
Dim i As Long, j As Long
With ActiveDocument.Tables(1)
For i = 1 To .Rows.Count
For j = 1 To .Columns.Count
.Cell(i, j).LeftPadding = 0
Next j
Next i
End With

I copied part of an XLS spreadsheet to create a Word table. The text in
many
[quoted text clipped - 6 lines]

My purpose is to do this within VBA, in case that changes the answer.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200911/1