Results 1 to 7 of 7

hey guys

Threaded View

alexsherman Need to strip data from one... 03-11-2014, 12:38 PM
Richard Buttrey Re: hey guys 03-11-2014, 12:40 PM
alexsherman Re: hey guys 03-11-2014, 12:54 PM
TMS Re: hey guys 03-11-2014, 12:59 PM
Richard Buttrey Re: Need to strip data from... 03-11-2014, 01:10 PM
alexsherman Re: Need to strip data from... 03-11-2014, 05:34 PM
Xx7 Re: hey guys 03-11-2014, 02:16 PM
  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need to strip data from one cell and place the contents into a different cell

    hey,

    first time poster long time lurker... I have an issue I can't seem to solve. I have an output in cell A1 that goes like this: GARCIA YASMINA (017015)
    What I need is a formula to remove (017015) and place it with out the parentheses in cell B1. So the output would be GARCIA YASMINA in cell A1 and 017015 in cell B1.

    Thanks so much guys!!!
    Last edited by alexsherman; 03-11-2014 at 12:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HI guys
    By drillerds in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-17-2013, 09:22 AM
  2. hi guys
    By zeroar in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 02-09-2013, 07:55 AM
  3. Hello Guys
    By Saintjp in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-05-2013, 08:01 PM
  4. Hi Guys!
    By elliotencore in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-21-2013, 07:15 PM
  5. Hi Guys
    By blueorange in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 01-04-2013, 12:04 PM

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