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.
Issue with text in a cell
- Thread starter CROW
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Assuming A1...
try =LEFT(A1,FIND("/",A1)-1)
AND
=MID(A1,FIND("/",A1)+1,5)
try =LEFT(A1,FIND("/",A1)-1)
AND
=MID(A1,FIND("/",A1)+1,5)