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

[SJR4347]

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.

 

[Ashish Mathur]

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

 

[Fred Smith]

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