Results 1 to 2 of 2

Thread: Issue with text in a cell

  1. #1

    Issue with text in a cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    In a sheet hat others populate I have a cell(s) that contain values like 1/1, 13/6, 5/42, 10/21, etc... where it could be either 1 or 2 digits both before and after the "/". I need to extract the text before and after the "/" to 2 different cells.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Assuming A1...

    try =LEFT(A1,FIND("/",A1)-1)

    AND

    =MID(A1,FIND("/",A1)+1,5)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •