+ Reply to Thread
Results 1 to 5 of 5

Return everything to the left of a character

  1. 06-22-2023, 08:38 AM #1
    kimi01
    kimi01 is offline
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    82

    Return everything to the left of a character

    In the attached I need a formula to remove everything to the left of the question mark in cell A1, so that it displays per B1.

    Thanks in advance!

    Left of.xlsx
    Reply With QuoteRegister To Reply
  2. 06-22-2023, 08:48 AM #2
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,418

    Re: Return everything to the left of a character

    Text to Columns
    Reply With QuoteRegister To Reply
  3. 06-22-2023, 08:49 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,787

    Re: Return everything to the left of a character

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 06-22-2023, 09:03 AM #4
    kimi01
    kimi01 is offline
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    82

    Re: Return everything to the left of a character

    Quote Originally Posted by Fluff13 View Post
    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Perfect, thank you!
    Reply With QuoteRegister To Reply
  5. 06-22-2023, 09:05 AM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,787

    Re: Return everything to the left of a character

    Glad to help & thanks for the feedback.
    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. [SOLVED] If Left b = left c return True False
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2017, 04:10 AM
  2. [SOLVED] Formula to return 2 spaces to the left of a character
    By Justair07 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-25-2017, 11:40 AM
  3. [SOLVED] Question about LEFT function-How to return a specific character of a string.
    By llomax83 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2016, 02:09 PM
  4. [SOLVED] How to remove 7 and 8 number character from cell A1 character start from left to right
    By nur2544 in forum Excel General
    Replies: 3
    Last Post: 11-20-2012, 10:03 PM
  5. Search for character & return values on left and right
    By mviggiano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2010, 10:13 AM
  6. Want to extract all character from the left before the /
    By feejo in forum Excel General
    Replies: 2
    Last Post: 08-19-2008, 07:18 AM
  7. Function to return Character Position of Xth character within a string
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

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