Remove character from imported data

J

jimmxz

I have a column of imported data that I want to convert to a number only.
The data includes 2 to 3 numbers, then a "/" and finally 1 or 2 more numbers.
I only want the left 2 or 3 numbers before the "/". Here is are some
examples:
Actual Wanted
100/0 100
100/10 100
55/5 55
55/10 55

Thanks for your help!
Jim
 
J

john

Use text to columns using the / as the seperator & delete the extra column
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
D

Dave Peterson

=LEFT(A1,SEARCH("/",A1&"/")-1)
will return text

if you want a number:
=--LEFT(A1,SEARCH("/",A1&"/")-1)
 
J

jimmxz

Thanks, I wasn't aware that it was that easy, however, I have to add a column
in next to the original one. Is there a way to force the extra column to be
inserted over farther?

Thanks again!
Jim
 
G

Gord Dibben

In third step of T to C just select the column with the zeros and "skip, do not
import"


Gord Dibben MS Excel MVP
 
Top