Results 1 to 5 of 5

Formula to remove a character first and last of the text in a cell

Threaded View

  1. 04-17-2024, 01:52 AM #1
    angie_lin
    angie_lin is offline
    Registered User
    Join Date
    09-28-2017
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    26

    Red face Formula to remove a character first and last of the text in a cell

    What is the formula to remove a character first and last of the text in a cell?
    Example" *123456789*, i want to remove the * in the beginning and end
    I tried this formula but i can only remove the first =MID(CELL, FIND("*", CELL) + 1, LEN(CELL))
    Last edited by angie_lin; 04-17-2024 at 04:03 AM.
    Reply With QuoteRegister To Reply
« 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] How do I remove all text in a cell after a specific character?
    By moi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  2. [SOLVED] How do I remove all text in a cell after a specific character?
    By Erik Millerd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. How do I remove all text in a cell after a specific character?
    By Erik Millerd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. [SOLVED] How do I remove all text in a cell after a specific character?
    By moi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  5. How do I remove all text in a cell after a specific character?
    By moi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] How do I remove all text in a cell after a specific character?
    By Erik Millerd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. How do I remove all text in a cell after a specific character?
    By Erik Millerd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. How do I remove all text in a cell after a specific character?
    By Erik Millerd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1