How do I format cells in Excel to make 175/5 read 175?
 

I want to copy a list of numbers from a web site into a spreadsheet. The
numbers all have a / in them, and this copies to the spreadsheet. Example
195/5. I would like to be able to format the cells so that the numbers will
read 195 (losing the / and any digits after it. Using another column with a
formula that would do this will also work.

Thanks.

How do I format cells in Excel to make 175/5 read 175?
 

Hi,

Select the column and go to Data Text to columns Delimited. Select / as
the delimiter

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"SJR4347" wrote in message
...
I want to copy a list of numbers from a web site into a spreadsheet. The
numbers all have a / in them, and this copies to the spreadsheet. Example
195/5. I would like to be able to format the cells so that the numbers
will
read 195 (losing the / and any digits after it. Using another column with
a
formula that would do this will also work.

Thanks.

How do I format cells in Excel to make 175/5 read 175?
 

Formatting cannot do what you want, as you have text, not a number.

You can use:
=left(a1,3)
to display what you want.

If you want the result as a number, use:
=--left(a1,3)

Regards,
Fred

"SJR4347" wrote in message
...
I want to copy a list of numbers from a web site into a spreadsheet. The
numbers all have a / in them, and this copies to the spreadsheet. Example
195/5. I would like to be able to format the cells so that the numbers
will
read 195 (losing the / and any digits after it. Using another column with
a
formula that would do this will also work.

Thanks.