Need formula

A

A.S.

Hello, I am looking for a formula that will allow me to take specific figures
from a cell before and after a "/".

Example: 3/12
So in one cell I need it to read 3 and in another cell I need it to read 12.

This has to be done with formula and not macro. Any thoughts?

Thanks.
 
T

Toppers

=LEFT(A1,FIND("/",A1)-1) will give 3

=MID(A1,FIND("/",A1)+1,255) will give 12

HTH
 
R

Ron Coderre

Hoping this isn't just homework.....
try this

For a text-fraction in A1 (example: 3/12)

B1: =LEFT(A1,FIND("/",A1)-1)

C1: =RIGHT(A1,LEN(A1)-FIND("/",A1))
or
C1: =MID(A1,FIND("/",A1)+1,255)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
M

Marcelo

hi A.S.

to the left number
=left(a2,search("/",a2,1)-1)
for the right
=right(a2,search("/",a2,1))

hth
regards from Brazil
Marcelo



"A.S." escreveu:
 
A

A.S.

Yes this helps. I just want to make sure that this is not based on a specific
position of the characters. meaning, its not jsut taking the first character
to the left of the "/", because I may have 10/12. Thanks for the help.
 
T

Toppers

No... it works by finding the "/" and selecting the number of characters to
the left or right.
 
R

Ron Coderre

As a potential alternative....

You could use text-to-columns to parse the text-fractions into the adjacent
cells.

Select the column of cells to be used

From the Excel main menu:
<data><text-to-column>
Delimited.....click the [Next] button
Delimiter.....Check: Other and enter / ...click the [Next] button
Destination...Select the cell to the right of the top cell in your list
Click the [Finish] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top