+ Reply to Thread
Results 1 to 5 of 5

How can I find a specific character (numeric) from a cell by position?

  1. #1
    Registered User
    Join Date
    07-14-2012
    Location
    Sylhet
    MS-Off Ver
    Excel 2010
    Posts
    3

    Lightbulb How can I find a specific character (numeric) from a cell by position?

    Cell A1 = 123456

    Now I need to find each number in different cell. It may be
    Cell A2 = 1
    Cell A3 = 2
    Cell A4 = 3
    Cell A5 = 4
    Cell A6 = 5

    I am new in excel so any who can help I will be very grateful to him/her.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: How can I find a specific character (numeric) from a cell by position?

    Write this in A2
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And pull down

  3. #3
    Registered User
    Join Date
    07-14-2012
    Location
    Sylhet
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: How can I find a specific character (numeric) from a cell by position?

    Thanks zbor. Now Its working. If I want to find from right which function I have to call

    Cell A1 = 123456

    Cell A2 = 6
    Cell A3 = 5
    Cell A4 = 4
    ....

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: How can I find a specific character (numeric) from a cell by position?

    Use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-14-2012
    Location
    Sylhet
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: How can I find a specific character (numeric) from a cell by position?

    To zbor: Thanks.

+ 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