+ Reply to Thread
Results 1 to 5 of 5

Retrieving first name

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Retrieving first name

    Dear All,
    I want to retrieve first name except exclamatory sign [!],here CELL A1 is my input data & from these I prefer to get below output in the CELL B1

    CELL A1(Input)
    !DBE04 : ZGSDRI1B01
    !MBE10 : JGSDRM1B33
    !ABE40 : HGSDRK1B43
    !ZBE55 : AGSDRE1B53

    CELL B1 (Output)
    DBE04
    MBE10
    ABE40
    ZBE55

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Retrieving first name

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

    Kaper

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Retrieving first name

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

    Assuming your data from "A1"


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Retrieving first name

    Hi Kaper, Appreciated, thanks

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Retrieving first name

    Hi avk, Appreciated, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Retrieving the last Non-blank Value using Look-up
    By ronkeakano in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2015, 01:41 PM
  2. [SOLVED] Retrieving top-5 names
    By versuswhat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-16-2015, 02:02 PM
  3. [SOLVED] Help with retrieving data
    By lvsmr2 in forum Excel General
    Replies: 7
    Last Post: 01-16-2013, 12:40 AM
  4. Retrieving the Last Value and the Last Character in a Row
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 02:25 AM
  5. Retrieving Web Data
    By leafsfan1967 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2005, 01:47 PM
  6. Retrieving Data
    By oldspice in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 04:36 PM
  7. [SOLVED] Retrieving Value
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2005, 12:06 AM

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