+ Reply to Thread
Results 1 to 3 of 3

Report Excel Find & Paste Formula

  1. #1
    Registered User
    Join Date
    08-03-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    V10
    Posts
    5

    Exclamation Report Excel Find & Paste Formula

    Hello,


    I have a list of product name in cell A containing country name and I wanted to bring put that country name into an adjacent cell. Do you have any formula to do this?

    sample

    Cell A
    Golden Apple India
    Red Apple China
    Black Grapes USA

    Output
    Cell B
    India
    China
    USA

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Report Excel Find & Paste Formula

    Use the formula "=RIGHT(A1,FIND(" ",A1,1))" in B1

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Report Excel Find & Paste Formula

    Try

    B1
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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. Replies: 1
    Last Post: 10-17-2016, 02:25 AM
  2. [SOLVED] paste the formula and find these is something wrong
    By hktom in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-28-2015, 06:22 AM
  3. Replies: 0
    Last Post: 07-27-2015, 01:06 PM
  4. Need a formula to find duplicate claims on a report
    By mariosot06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2014, 02:14 PM
  5. Replies: 2
    Last Post: 06-29-2011, 04:35 PM
  6. find and paste formula
    By Taru in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2006, 03:55 PM
  7. Where do I find Report Manager for Excel 2003?
    By Brian in forum Excel General
    Replies: 1
    Last Post: 08-24-2005, 11:05 AM

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