+ Reply to Thread
Results 1 to 3 of 3

Delete everything from cells besides the first word in each cell

  1. #1
    Registered User
    Join Date
    01-17-2019
    Location
    Germany
    MS-Off Ver
    varying
    Posts
    19

    Question Delete everything from cells besides the first word in each cell

    Hello,
    i need to evaluate a paleo diversity database in RStudio but to be able to do the i need to "clean up" the database first. I do not have much excel experience yet so please excuse my probably mundane questions/requests.



    If species are given like "Tetradium huronense" i need to get rid of everything after the genus (e.g. Tetradium huronense -> Tetradium)
    maybe this could be done with a split funtion of some sort.
    Basically the funtions needs to delete everything from the cells of the D column besides the first name






    Please help me solve this by giving step by step instructions since all ive done so far using excel was plotting graphs and doing some simple automated calculations.


    Thanks in advance
    afridelle
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Delete everything from cells besides the first word in each cell

    This is a formula to keep only the first word from cell:
    =IF(ISERR(FIND(" ",D8)),"",LEFT(D8,FIND(" ",D8)-1))
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    01-17-2019
    Location
    Germany
    MS-Off Ver
    varying
    Posts
    19

    Re: Delete everything from cells besides the first word in each cell

    Thank you :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel vba to find and delete a certain word plus the adjacent word in a cell
    By hoss88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2018, 08:46 AM
  2. Delete cell and adjacent cells if cell contains specific word
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2015, 05:19 PM
  3. delete rows with cells that contain some word
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2014, 12:20 PM
  4. How To Delete Cells That Contain Certain Word excel vba
    By nareshkt in forum Excel General
    Replies: 4
    Last Post: 10-18-2013, 03:20 PM
  5. How To Delete Cells That Contain Certain Word excel vba
    By nareshkt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2013, 03:10 PM
  6. [SOLVED] Find cells which contain specific word, delete cells and shift left.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2012, 07:00 AM
  7. Delete word from multiple cells
    By Leslie in forum Excel General
    Replies: 2
    Last Post: 11-15-2005, 01:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1