Hi
In column A have some details in that need to extract the test being with " VIA at xy "
extracted value copied to Column B. Through VBA code
excel attached .
Manually fliting method is not comfortable to repeated process.
Hi
In column A have some details in that need to extract the test being with " VIA at xy "
extracted value copied to Column B. Through VBA code
excel attached .
Manually fliting method is not comfortable to repeated process.
Here is a formula that can work: =IF(ISNUMBER(SEARCH("VIA at xy",A1)),A1,"")
Click the * to say thanks.
Do you want to pull out " VIA at xy " or the numbers in parenthesis after that text. I.e, column B, row 39 = "(-140.0513 -29.2162) " ? or just " VIA at xy " ?
I want (-140.0513 -29.2162)
Try
Please Login or Register to view this content.
the value extracting , but I am looking extracted value copied like B1 B2 B3 etc. not a equal adjacent row.
Please post a file with the expected result. I’m having trouble understanding your requirements.
Image attached for references, results starts from coloumn B1
Give this code a try: I also entered the VDD value in column C and highlighted the first instance of each pair in red.
Please Login or Register to view this content.
the above code not working, my excepted output entered manually in excel sheet please refer it. excel attached.
in column A have via at xy and part of net name those remaining value extracted to column B &C
Hi,
well elaborate at least your logic as for example the red color does not match the column A …
And do you really need duplicates ?!
This code will populate B and C with each items information once. Let us know if thisis what you are expecting.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks