Excel 2007 : Remove the text after the number

I would like for the number in the beginning to stay and delete everything including the "/"

123456 / Home so 123456
789012 / Remove so 789012

Try this...
=LEFT(A1,FIND(" ",A1)-1)
or
=LEFT(A1,FIND("/",A1)-2)

Does that help?

If you want to do this in situ, you can select the column, do a CTRL+H (Find/Replace) and enter this in the Find what box: /*
Leave the other box blank and hit Replace All

I like the "in situ", Vito

yeah, sometimes I like to through out a little Latin ad hoc or ad libitum

Originally Posted by NBVC

yeah, sometimes I like to through out a little Latin ad hoc or ad libitum

"Nunc est bibendum" also has a nice ring to it

Originally Posted by Jerseynjphillypa

how would i do a vlookup if I all read have a number in another list but want to extract the text part as per ron advice

=VLOOKUP(Sheet2!A2,Sheet3!$A:$A,1,FALSE) so
=LOOKUP(Sheet2!A2,(LEFT(Sheet3!$A:$A,FIND("/",Sheet3!$A:$A)-2),1,false)

Can you post some samples for cell A2 and for the $A:$A range?

Perhaps you can use Sumif or Vlookup with wildcard

e.g.

=SUMIF(Sheet2!$A$2:$A$5,A2&" /*",Sheet2!$B$2:$B$5)
or

=VLOOKUP(A2&" /*",Sheet2!$A$2:$B$5,2,FALSE)

Originally Posted by Ron Coderre

Try this...
=LEFT(A1,FIND(" ",A1)-1)
or
=LEFT(A1,FIND("/",A1)-2)

Does that help?

Thanks Ron,
Its really simple & helpful..