+ Reply to Thread
Results 1 to 2 of 2

Add the word ERROR in the 133rd position after a string of characters in a cell

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    Milwaukee, WI
    MS-Off Ver
    Excel 2007
    Posts
    1

    Add the word ERROR in the 133rd position after a string of characters in a cell

    I want to use VB to add the word ERROR after the end of a string in a cell. The E in ERROR should start in the 133rd character position of the cell. I want to do this for multiple cells with strings of varying lengths and I don't want to disturb the original string.

    Positions and strings
    .................................1
    .................................3
    1 2 3..........................3
    string value one............ERROR
    string value two............ERROR
    string value three..........ERROR
    string value four............ERROR

    Hopefully I've provided enough information. Thanks.

  2. #2
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Add the word ERROR in the 133rd position after a string of characters in a cell

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1