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?

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"kana" wrote:

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?