If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
In Word 2003 how to insert characters before all cell markers
I want to insert a character before the cell marker in many cells in a table.
I can't use the find and replace feature. There must be a way to do this (or to delete a character before every cell marker). Can someone help me? |
#2
|
|||
|
|||
In Word 2003 how to insert characters before all cell markers
Hi MathKing,
You could add text to the end of each selected cell via a macro like: Sub AddDemo() Dim oCel As Cell, StrTxt As String StrTxt = InputBox("What is the text to insert at the end of each selected cell") For Each oCel In Selection.Cells oCel.Range.InsertAfter (StrTxt) Next End Sub Similarly, you can delete the last character with: Sub DelDemo() Dim oCel As Cell, lStr As Long For Each oCel In Selection.Cells lStr = oCel.Range.Characters.Count If lStr 1 Then oCel.Range.Characters(lStr - 1).Delete Next End Sub -- Cheers macropod [Microsoft MVP - Word] "MathKing" wrote in message ... I want to insert a character before the cell marker in many cells in a table. I can't use the find and replace feature. There must be a way to do this (or to delete a character before every cell marker). Can someone help me? |
#3
|
|||
|
|||
In Word 2003 how to insert characters before all cell markers
Hi Macropod.
Again a very nice little macro set. Question though, how can the first macro be changed to deal with any and all tables within a document not just selected cells, and also have the text to be inserted preset? Many thanks DeanH "macropod" wrote: Hi MathKing, You could add text to the end of each selected cell via a macro like: Sub AddDemo() Dim oCel As Cell, StrTxt As String StrTxt = InputBox("What is the text to insert at the end of each selected cell") For Each oCel In Selection.Cells oCel.Range.InsertAfter (StrTxt) Next End Sub Similarly, you can delete the last character with: Sub DelDemo() Dim oCel As Cell, lStr As Long For Each oCel In Selection.Cells lStr = oCel.Range.Characters.Count If lStr 1 Then oCel.Range.Characters(lStr - 1).Delete Next End Sub -- Cheers macropod [Microsoft MVP - Word] "MathKing" wrote in message ... I want to insert a character before the cell marker in many cells in a table. I can't use the find and replace feature. There must be a way to do this (or to delete a character before every cell marker). Can someone help me? |
#4
|
|||
|
|||
In Word 2003 how to insert characters before all cell markers
Hi Dean,
You could use something like: Sub AddAllDemo() Dim oTbl As Table, oCel As Cell, StrTxt As String StrTxt = "MyText" For Each oTbl In ActiveDocument.Tables For Each oCel In oTbl.Cells oCel.Range.InsertAfter (StrTxt) Next Next End Sub -- Cheers macropod [Microsoft MVP - Word] "DeanH" wrote in message ... Hi Macropod. Again a very nice little macro set. Question though, how can the first macro be changed to deal with any and all tables within a document not just selected cells, and also have the text to be inserted preset? Many thanks DeanH "macropod" wrote: Hi MathKing, You could add text to the end of each selected cell via a macro like: Sub AddDemo() Dim oCel As Cell, StrTxt As String StrTxt = InputBox("What is the text to insert at the end of each selected cell") For Each oCel In Selection.Cells oCel.Range.InsertAfter (StrTxt) Next End Sub Similarly, you can delete the last character with: Sub DelDemo() Dim oCel As Cell, lStr As Long For Each oCel In Selection.Cells lStr = oCel.Range.Characters.Count If lStr 1 Then oCel.Range.Characters(lStr - 1).Delete Next End Sub -- Cheers macropod [Microsoft MVP - Word] "MathKing" wrote in message ... I want to insert a character before the cell marker in many cells in a table. I can't use the find and replace feature. There must be a way to do this (or to delete a character before every cell marker). Can someone help me? |
Thread Tools | |
Display Modes | |
|
|