+ Reply to Thread
Results 1 to 11 of 11

value before ";"

  1. 10-29-2020, 04:42 AM #1
    Ben Saed
    Ben Saed is offline
    Registered User
    Join Date
    07-10-2013
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    8

    value before ";"

    Guys, Looking for a help
    I've values in cell 39.4;25984.17;2020-10-07 00:00:00.0 & I need to pick all the values before the seperator that's ";".

    Thanks in Advance.

    Ben
    Reply With QuoteRegister To Reply
  2. 10-29-2020, 05:07 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: value before ";"

    There are two semi-colons - please be more specific.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-29-2020, 05:08 AM #3
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: value before ";"

    Hi, Assuming cell as A1,

    b1=
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    drag it across..
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  4. 10-29-2020, 05:09 AM #4
    sweep
    sweep is offline
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: value before ";"

    Hi,

    For the first value (39.4),

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


    For the second value (25984.17),

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
    Reply With QuoteRegister To Reply
  5. 10-29-2020, 05:38 AM #5
    Ben Saed
    Ben Saed is offline
    Registered User
    Join Date
    07-10-2013
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: value before ";"

    Guys,
    Many apologies, in my case 39.4;25984.17;2020-10-07 00:00:00.0 values before the first ";" should be picked up.
    Reply With QuoteRegister To Reply
  6. 10-29-2020, 05:40 AM #6
    Ben Saed
    Ben Saed is offline
    Registered User
    Join Date
    07-10-2013
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: value before ";"

    value in c14 is 9.6;20353.72;2020-10-05 00:00:00.0 & your first formula brings 20353.72;2020-10-05 00:00:00.0
    Reply With QuoteRegister To Reply
  7. 10-29-2020, 05:43 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: value before ";"

    Problem is, you have not told us what you want the result to be ...
    Reply With QuoteRegister To Reply
  8. 10-29-2020, 05:49 AM #8
    Ben Saed
    Ben Saed is offline
    Registered User
    Join Date
    07-10-2013
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: value before ";"

    Ok Sorry,
    I've values in cell c1 9.6;20353.72;2020-10-05 00:00:00.0 & I need to get whatever the value before the first semicolon so the result should come in cell c2 9.6.

    Thanks a lot
    Reply With QuoteRegister To Reply
  9. 10-29-2020, 08:07 AM #9
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: value before ";"

    Hi C2=
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 10-29-2020, 09:54 AM #10
    Ben Saed
    Ben Saed is offline
    Registered User
    Join Date
    07-10-2013
    Location
    Geneva, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: value before ";"

    Brilliant !!!! Thanks mate
    Reply With QuoteRegister To Reply
  11. 10-29-2020, 09:55 AM #11
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: value before ";"

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas
    By Windyz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Using "index", "match", "min", "abs", to find the closest value in multiple criteria
    By escariojm in forum Excel General
    Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  7. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1