Hi there,
I have a cell that has part number and description in one cell and I need to split them up. e.g.
I already have this:
Please Login or Register to view this content.
Which isolates the part number, how can I get "the rest of the cell without this part number" now?Please Login or Register to view this content.
Kind regards
Rob
Last edited by Rob K; 07-07-2015 at 07:06 AM.
give some examples or attach a sample excel file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Like this, maybe...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
From the above example "AWSGM2.5 - Wrench, Metric, Hex, Combination Tand L-Shape, Soft Grip, Blue Handle, 2.5mm" is initially all in one cell. i need to split it into two cells. The formula I have there will give me the part number
AWSGM2.5
how do I get the rest into one cell
- Wrench, Metric, Hex, Combination Tand L-Shape, Soft Grip, Blue Handle, 2.5mm ( I want this in one cell not 13 cells)
Sorry, i hadn't seen your edited example. Paste this into D2 and drag across 1 column. It will work perfectly when the separator is a -. If this is not always the case, please post a representative group of examples...
=TRIM(MID(SUBSTITUTE("-"&$C2,"-",REPT(" ",125)),125*COLUMNS($A:A),125))
With the original value in A1
and the Awesome2.5 in B1
In C1
=REPLACE(A1, 1,LEN(B2)+1, "")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks