After extracting first word in string from column A, using:
In B1 use:
=LEFT(A1,FIND(" ",A1)-1)
how do you delete what you've just extracted for C1, leaving everything else in string?
Thanks
After extracting first word in string from column A, using:
In B1 use:
=LEFT(A1,FIND(" ",A1)-1)
how do you delete what you've just extracted for C1, leaving everything else in string?
Thanks
This should work for you; it uses the MID function and the FIND function and the LEN function:
=MID(A1,(FIND(" ",A1,1)+1),LEN(A1)-FIND(" ",A1,1))
Regards,
theDude
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks