Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Remove x First Characters In A String

  1. #1
    Join Date
    7th June 2005
    Posts
    16

    Remove x First Characters In A String

    I have a string like

    AAJDGYE030000460

    How can I remove the first character in a macro?

    I need to look at the second,third, and forth character

    Bob

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,331

    Re: Removeing First Character In A String

    Take a look at the MID function. It's available in both the worksheet and in VBA. The LEFT and RIGHT functions are also useful.
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

  3. #3
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,901

    Re: Removeing First Character In A String

    VB:
    =RIGHT(A1,LEN(A1)-1) 
    
    
    will remove the first character.

    VB:
    =mid(A1,2,1) 
    
    
    will give the second. Change 2 to 3/4 for others.

    VB:
    =mid(A1,2,3) 
    
    
    will give 2nd to 4th.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th June 2005
    Posts
    16

    Re: Removeing First Character In A String

    Thanks....

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 11
    Last Post: February 18th, 2014, 23:56
  2. Remove non-alphanumeric characters from a string
    By tbmbob in forum EXCEL HELP
    Replies: 20
    Last Post: August 1st, 2012, 00:05
  3. Remove Last x Characters From String
    By ExcelChicky in forum EXCEL HELP
    Replies: 3
    Last Post: January 22nd, 2008, 05:55
  4. Remove Characters From End Of String Only
    By Benny Hays in forum EXCEL HELP
    Replies: 6
    Last Post: December 22nd, 2006, 07:21
  5. Remove Characters from a string
    By Robert B in forum Excel and/or Access Help
    Replies: 2
    Last Post: May 5th, 2006, 18:50

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
  •  
porno