Hi All
I have a database to split data into three different columns in the second column B I managed with a formula, but stuck in column C and D because as data are not uniform.
Annexed sample
Thanks
Hi All
I have a database to split data into three different columns in the second column B I managed with a formula, but stuck in column C and D because as data are not uniform.
Annexed sample
Thanks
See if the attached does what you want.
hi
Formula for code
=LEFT(A2,FIND(" ",A2)-1)
Formula for "origin"
=MID(A2,SEARCH(" ?? ",A2)+1,2)
Formula for "description"
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,E2,""),"Total","")," "&G2&" ",""))
Appreciate the help? CLICK *
Hi
The results are ok, but there are some lines that did not give the expected results.
eg( sample row 3) 22042190 WINES ZA (SADC R539722) Total should read 22042190 WINES (SADC R539722) ZA
ROW 3,4,8,10,11 should read same,this is a sample, the database have minimum 500 rows like this uneven .Very tedious.
Is it possible.
Thanks
Hi
Great many thanks
Works marvellously
thanks for your help
You're welcome. Glad you found a solution.
Hi
You are welcome and thanx for reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks