Results 1 to 3 of 3

[Q] Trying to get partial (delimited) text into an adjacent cell

Threaded View

  1. 05-24-2022, 12:49 AM #1
    John IV
    John IV is offline
    Registered User
    Join Date
    05-24-2022
    Location
    Washington, USA
    MS-Off Ver
    365 current
    Posts
    2

    [Q] Trying to get partial (delimited) text into an adjacent cell

    Hi all, I have three columns, the first has the book with author in parens.
    I need to get the author's last name into the second column for about 400 rows. Thanks!
    Attached worksheet and pic.

    1.png
    Attached Files Attached Files
    Last edited by John IV; 05-24-2022 at 01:31 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Please help on COUNTIF Partial text, partial text/words also contained in other texts
    By maria.h in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2020, 10:18 PM
  2. Insert complete text and numeric values from one cell as partial text in another cell
    By 6DollarRooster in forum Excel General
    Replies: 2
    Last Post: 03-01-2016, 08:01 PM
  3. [SOLVED] Count partial text matches in adjacent column
    By joshkvt in forum Excel General
    Replies: 6
    Last Post: 08-11-2014, 12:01 PM
  4. Count Delimited Text within a Cell
    By JE2BD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2014, 06:39 PM
  5. [SOLVED] How to compare partial text in two columns and return value from adjacent cell
    By Ghys772 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-07-2014, 07:43 AM
  6. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 PM
  7. Importing Delimited Text/Exporting Delimited Text Loop
    By cecarter74 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2009, 01:17 PM

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