Merging two separate cells into a fraction question

**mcb87** · 06-17-2010, 02:58 PM

All,

I'm trying to merge two cells together, and turn them into a single cell separated by "/"

Example:

A1: 0
B1: 4

Desired result in cell C1: 0/4

Can anyone get me a quick response? I think I just need to do something with a text function then I can just copy/paste values into another column, but I have had no luck thus far.

Thanks!

**Dulanic** · 06-17-2010, 03:09 PM

If you are OK with text just do the following in C1

=A1&"/"&B1

**6StringJazzer** · 06-17-2010, 03:11 PM

I tried Format, Fraction but for zero values it just shows 0.

Do you need to maniuplate the resulting fraction as a number? If not, and you just need to show it, then Dulanic's solution is the simplest.