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?