Hi,
The nature of data is similar to it at posthttps://www.excelforum.com/excel-pro...-brackets.html ,I have another things to extract that is the data after last dot(.) or comma(,) if exists,else leave intact.Workbook is enclosed for your kind reference.Here,data is the original worksheet & required is the output worksheet.However the result is required in the same worksheet and not is seperate worksheet which have already done in above link as contributed by forum contributor "Jindon"
review your last time have include extracting numeric require, try below code:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by jindon; 12-09-2017 at 07:44 AM.
In the above attachment,the code does not extract the last data i.e D8 which has a dot(.) as mentioned in required worksheet.
Secondly,column C & D data is omitted/deleted rather than shifting right hand side which you have done in earlier post when the code is run.
Thirdly,when I run your code in my original workbook, a run time error '9' occurs.subscript out of range, & on debug at line 10 yellow highlight shows at "ar(i, 1) = Trim(t(0))" also prompt an error "can't execute code in break mode"
I hope this will take into consideration & will revise accordingly.
Thanx once again for your valuable time to my post .
Last edited by paradise2sr; 12-09-2017 at 07:37 AM.
Formula spelling
In C2
=SUBSTITUTE(LEFT(B2,IFERROR(SEARCH(",",B2)-1,LEN(B2))),".","")
In D2
=SUBSTITUTE(RIGHT(B2,IFERROR(LEN(B2)-SEARCH(",",B2),0)),".","")
then drag down
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Originally Posted by jindon
Please Login or Register to view this content.
Thanx your code did a fantastic works.My problem has now been solved as usual with your kind help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks