LinkBack URL
About LinkBacks
Hi I have a unique request that I hope someone can assist me.
I am trying to pull out just the 6 digit skus in the cell that has these error messages verbiage.
Please see the attached file for an example.
Thank you!!
YR
Hi I have a unique request that I hope someone can assist me.
I am trying to pull out just the 6 digit skus in the cell that has these error messages verbiage.
Please see the attached file for an example.
Thank you!!
YR
I didn't get any idea, so I've written VBA for You (I hope you can use macro in your excel).
as in your file, based on huge string in cell A1, when you run this macro you will get all SKUs listed in cell A2:AX, depends how many SKU macro gets.
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
If I've interpreted correctly try this in cell B5 and fill down until you get blanks.Formula:
Please Login or Register to view this content.
Dave
A3 needs to be blank
Please try at AB3 and drag down
=IFERROR(MID(A$1,FIND("SKU",A$1,FIND(A2,A$1))+4,6),CHAR(9))
Hi, I am attaching the full array of data of where I'm trying to pull out just the list of skus:
I can't seem to copy it all into one cell and use your formula. I saved the array in notepad, can you tell me what is the best way to do this? Thank you so much for your time!
YR
Just one way to do.
Copy text to A1, it will split to 4 rows or more
C1 drag down and across
=IFERROR(MID($A1,FIND("SKU",$A1,FIND(B1,$A1))+4,6),CHAR(9))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks