conditional: stop function under certain condition

K

kana

Hi, i have a question about stopping a function at certain specified point.
i'm trying to simplify the list with data entered as follows: "xxxxx xx
xxxxxx"
i just need the first part, so i want to trim the part after the long space.
length of the first part ranges, with or without space in between. is there a
way to use function like =LEFT and stop when it reaches >2 space?
 
P

Pranav Vaidya

Hi Kana,

I think this will help. Assuming your text is in cell A1, enter this formula
in cell, say B1
=MID(A1,1,SEARCH(" ",A1,1)-1)

HTH,
 
Top