• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Num from String

Afarag

Member
Hello,

please i need your support in extracting Num from String as i have an array which contain a values that values be Num or string or Num concatenate String.
i need to export the num records only.
then repeat that extracted record till the next one
0
 

Attachments

  • Extract.xlsx
    26.5 KB · Views: 8
Hi,

Try the below in B2 and drag it down

IF(COUNT(SEARCH(ROW($1:$10)-1,$A2))>0,LEFT($A2,MATCH("*",T(1/ISNUMBER(--MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1))))),$B1)

To be acknowledged with CTRL + SHIFT + ENTER
 
Hello Asheesh,

i applied your function and got a result, but i have an issue that my sheet have floating when remove that floating via "text to Columns" option the array parenthesis "{}" removes and got #VALUE!.

so can i use a nested formula to apply this logic or how can i ignore these floating.

i uploaded the main sheet.
 

Attachments

  • merged_document.xlsx
    681.1 KB · Views: 6
I may have misunderstood...just double checking, are you trying to use Text to Columns on the Nested function

Also, can you highlight an example or two basis the attached..and what are you aiming at..
 
Hello Ashesh,
thanks a lot for your support as your function get the result totally true, for a bout my last port it was an issue and solved

thanks a lot,
 
Back
Top