Closed Thread
Results 1 to 4 of 4

Forluma to pull ASIN from anywhere in the row

  1. 08-27-2018, 02:11 PM #1
    keith81591
    keith81591 is offline
    Registered User
    Join Date
    08-13-2018
    Location
    U.S
    MS-Off Ver
    2016
    Posts
    53

    Forluma to pull ASIN from anywhere in the row

    Hello, friends. Today I am trying to write a formula that will pull any 10 character ASIN that begins with a "B". The Asin will always begin with a B and be 10 characters long. I am only wanting the formula to pull in the asin from the row it is entered into, it can be found in several different columns. Thank you in advance for any help you can provide!
    See attached sample data.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-27-2018, 02:16 PM #2
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Forluma to pull ASIN from anywhere in the row

    Duplicate thread.

    See your other thread for an answer.

    https://www.excelforum.com/excel-for...mula-help.html
    Reply With QuoteRegister To Reply
  3. 08-27-2018, 02:19 PM #3
    keith81591
    keith81591 is offline
    Registered User
    Join Date
    08-13-2018
    Location
    U.S
    MS-Off Ver
    2016
    Posts
    53

    Re: Forluma to pull ASIN from anywhere in the row

    Quote Originally Posted by 63falcondude View Post
    Duplicate thread.

    See your other thread for an answer.

    https://www.excelforum.com/excel-for...mula-help.html
    Sorry about that. This one has the attachment from the beginning. Thanks
    Reply With QuoteRegister To Reply
  4. 08-27-2018, 03:31 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,982

    Re: Forluma to pull ASIN from anywhere in the row

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
Closed 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. Macro that copies a cell into Amazon search and returns Amazon product ASIN
    By kwiddoes23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2017, 06:28 AM
  2. [SOLVED] min max and sum forluma assistance
    By pietf in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2016, 01:39 AM
  3. How to pull vlookup or pull up multiple values from 2nd sheet- Need help fast.
    By shadowknight in forum Excel General
    Replies: 1
    Last Post: 04-20-2015, 03:18 PM
  4. [SOLVED] Excel does not pull value from the cell - appears to pull formula
    By enjoyexcel in forum Excel General
    Replies: 2
    Last Post: 01-06-2015, 11:42 AM
  5. [SOLVED] Apply forluma on formulated rows
    By Sai Prashanth in forum Excel General
    Replies: 10
    Last Post: 09-26-2014, 03:43 PM
  6. Extending Forluma to last row
    By TonyforVBA in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2011, 12:54 PM
  7. [SOLVED] "Asin" doesn't work in VB for Excel macros
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2006, 08:20 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