Hi,
I need to select the first word in a string of text of varying length and the first word will be of varying length as well.
Can anyone assist with the formula please?
Many thanks
Hi,
I need to select the first word in a string of text of varying length and the first word will be of varying length as well.
Can anyone assist with the formula please?
Many thanks
Try this formula:
=LEFT(A1,FIND(" ",A1)-1)
A1 is the cell where the text is.
This assumes that your text is separated by a space, which is why " " is there. If the words used, for instance, a dash as a separator, you would put "-" instead of the blank space inbetween the quotation marks.