Results 1 to 7 of 7

trying to locate the first space and display the text to the right of it.

Threaded View

weedfiend trying to locate the first... 11-08-2013, 12:35 AM
benishiryo Re: trying to locate the... 11-08-2013, 12:46 AM
weedfiend Re: trying to locate the... 11-08-2013, 12:57 AM
weedfiend Re: trying to locate the... 11-08-2013, 01:15 AM
FDibbins Re: trying to locate the... 11-08-2013, 01:23 AM
weedfiend Re: trying to locate the... 11-08-2013, 01:41 AM
FDibbins Re: trying to locate the... 11-08-2013, 02:58 PM
  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    19

    trying to locate the first space and display the text to the right of it.

    I87 = Intermediate Water elemental
    I am displaying the first word in a cell here
    =IF(I87="","",LEFT(I87,FIND(" ",I87,1)))

    Trying to display second and third words in another cell.
    I have several different combinations In I87 that are generated randomly.
    I87 = Minor Fey
    I87 = Intermediate Water elemental
    I87 = Major Red dragon
    what I am going for is a cell that splits up power level and type into two different cells
    so I can index a chart for what is displayed.
    what is the formula for this please and thanks in advance.
    trying to stay away from macros
    Attached Files Attached Files
    Last edited by weedfiend; 11-08-2013 at 01:35 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display text between space X and X from cell.
    By carl5156 in forum Excel General
    Replies: 9
    Last Post: 02-19-2014, 11:10 PM
  2. Simple code to locate a word and remove space in front
    By yiannis1925 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2011, 10:14 AM
  3. How to Locate a value and display the match item
    By wpm7113 in forum Excel General
    Replies: 7
    Last Post: 05-16-2008, 07:54 AM
  4. Using FIND function to locate space between first and last name
    By Dennis_in_nh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 03:20 PM
  5. VBA code using Find to locate text and display the Cell Range.
    By slimla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-27-2005, 05:05 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