+ Reply to Thread
Results 1 to 4 of 4

Return all text to the right of a point in a word

  1. 01-19-2017, 03:24 PM #1
    stephme55
    stephme55 is offline
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Return all text to the right of a point in a word

    How can I return all text to the right of the 8th character?
    Reply With QuoteRegister To Reply
  2. 01-19-2017, 03:25 PM #2
    Raphaelp
    Raphaelp is offline
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Return all text to the right of a point in a word

    =mid(a2,9,100)
    Reply With QuoteRegister To Reply
  3. 01-19-2017, 03:43 PM #3
    MrShorty
    MrShorty is online now
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Return all text to the right of a point in a word

    The RIGHT() function: https://support.office.com/en-us/art...b-f19e1786cf2f
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  4. 01-19-2017, 03:50 PM #4
    Amanda Wilso
    Amanda Wilso is offline
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Return all text to the right of a point in a word

    =LEFT(RIGHT(A1,8),1)
    Or
    =MID(A1,LEN(A1)-7,1)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Use Word to Find Text and return the following 10 characters
    By baggieade in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-11-2015, 07:45 AM
  2. Using VBA to find a word in a line of text then return data to the right of it
    By DAN_AO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2015, 04:29 AM
  3. [SOLVED] Find word in text string and return word adjacent to the left
    By eadamquinn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2014, 03:22 PM
  4. Need to find a word in text and return corresponding value
    By yafirst in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2014, 11:52 AM
  5. [SOLVED] Return text string from charcater start and end point
    By DevfromCorrie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2014, 10:23 AM
  6. Search a text string to see if it contains a word from a defined list, return that word
    By RCdude in forum Excel General
    Replies: 2
    Last Post: 08-05-2013, 04:45 PM
  7. [SOLVED] Formula to return a word from string of text
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-28-2013, 05:17 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1