• 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.

pls solve this query!!

Hi Ramesh,

Try this in H10 and copy down:

Code: 
=MID(INDEX($H$3:$L$3,,ROWS(H$10:H10)),SEARCH(", ",INDEX($H$3:$L$3,,ROWS(H$10:H10)))+1,IFERROR(SEARCH("-",INDEX($H$3:$L$3,,ROWS(H$10:H10)))-2-SEARCH(", ",INDEX($H$3:$L$3,,ROWS(H$10:H10))),255))&" "&MID(INDEX($H$3:$L$3,,ROWS(H$10:H10)),1,SEARCH(", ",INDEX($H$3:$L$3,,ROWS(H$10:H10)))-1)

Regards,
 
Somendra Misra said:
Hi Ramesh,

Try this in H10 and copy down:

Code: 
=MID(INDEX($H$3:$L$3,,ROWS(H$10:H10)),SEARCH(", ",INDEX($H$3:$L$3,,ROWS(H$10:H10)))+1,IFERROR(SEARCH("-",INDEX($H$3:$L$3,,ROWS(H$10:H10)))-2-SEARCH(", ",INDEX($H$3:$L$3,,ROWS(H$10:H10))),255))&" "&MID(INDEX($H$3:$L$3,,ROWS(H$10:H10)),1,SEARCH(", ",INDEX($H$3:$L$3,,ROWS(H$10:H10)))-1)

Regards,
Click to expand...
thnks SM Sir n any else method???
 
You must log in or register to reply here.
Back
Top