conditional: stop function under certain condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel code, end function? 0
Conditional Formatting from a group 6
Extracting text from right to left using MID and FIND 6
Excel Repeating a RAND() function under certain conditions 0
Conditional formatting 'Named Range' dilemma 5
sumif function in excel for multiple conditions instead of one 3
Using VLookup and Conditional Formatting 4
Split text to multiple cells 4

Back
Top