Need help with extracting values

**zarealshook** · 12-12-2012, 05:22 AM

Hi All,

Can someone be kind enough to help me with the below, cause I tried a lot of solutions with no luck at all.

I usually have my column of QTY. this way (2.000 EACH) and sometimes the QTY. is any value 40,100,540,865,1000...etc (NUMBER.000 EACH/SET)

what I need is to extract whatever number in that cell in separate column and the EACH/SET in another column.

Any reply with excel sheet example would be of a great help...

Regards,

Zarealshook

**:) Sixthsense :)** · 12-12-2012, 05:24 AM

Please attach a sample workbook with expected output for our workings and better understanding.

**benishiryo** · 12-12-2012, 05:31 AM

hi Zarealshook, i'm assuming the brackets are not included? and if your data is in A1, try this in B1
=LEFT(TRIM(A1),FIND(" ",TRIM(A1))-1)+0

and this in C1:
=MID(TRIM(A1),FIND(" ",TRIM(A1))+1,LEN(A1))

**zarealshook** · 12-12-2012, 05:56 AM

Very much thank you benishiryo for your great help! It really works fine...

I do appreciate your readiness for help Sixthsense. Problem was solved.

Regards,

Zarealshook