conversion help

  • Thread starter Thread starter Yellow007
  • Start date Start date
Y

Yellow007

Hi,

I use a spreadsheet to keep odd on the horses, however the cell that
contains the odds is text ie 2-1, 3-1 etc I want to know is there an
easy way to display the odds as 2/1 3/1 etc this needs to be done
automatically when the data is copied into the spreadsheet via a web
querry.

any suggestions would be helpful,

thanks
 
Yellow007,

If the 2-1 is in cell B2 then =LEFT(B2,FIND("-",B2,1)-1) & "/" &
MID(B2,FIND("-",B2,1)+ 1,LEN(B2)) will do what you ask.
 
Hi,

I use a spreadsheet to keep odd on the horses, however the cell that
contains the odds is text ie 2-1, 3-1 etc I want to know is there an
easy way to display the odds as 2/1 3/1 etc this needs to be done
automatically when the data is copied into the spreadsheet via a web
querry.

any suggestions would be helpful,

thanks
Click to expand...

If the string '2-1 is in A1, then:

=SUBSTITUTE(A1,"-","/")

Ensure when you import the data that the data is text, otherwise Excel may
convert it into a date.


--ron
 
Yellow007,

If the 2-1 is in cell B2 then =LEFT(B2,FIND("-",B2,1)-1) & "/" &
MID(B2,FIND("-",B2,1)+ 1,LEN(B2)) will do what you ask.
Click to expand...

or, more simply

=SUBSTITUTE(B2,"-","/")


--ron
 
Thanks Ron,

That worked sorry to be a pain in jack but would it be posible to writ
a formula that checked the next cell down in the list and did the sam
thing ( ie put some sort of loop in there until all the cells had bee
converted ?) rather than having to type the formula in each cell ?

Many Thanks
Yellow00
 
Copy the formula by selecting the first cell with the formula, move the
cursor to the lower right hand corner
then left click mouse and drag down (or double click lower right hand
corner)
 
Thanks Ron,

That worked sorry to be a pain in jack but would it be posible to write
a formula that checked the next cell down in the list and did the same
thing ( ie put some sort of loop in there until all the cells had been
converted ?) rather than having to type the formula in each cell ?

Many Thanks
Yellow007
Click to expand...

Did you get Peo's message for how to copy the formula down?

======================
Copy the formula by selecting the first cell with the formula, move the
cursor to the lower right hand corner
then left click mouse and drag down (or double click lower right hand
corner)
============================

When you move the cursor to the lower right hand corner, you should see a
little cross-hair pop up.


--ron
 
Back
Top