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

Text extraction from single cell to multiple cells

Juniad

Active Member
Dear experts,
I am facing some challenging task and unable to find the solution. Attached the sample sheet where I want to extract the name, number etc. from single cell to multiple cells. Manual result added in sample sheet. Looking forward your response.
 

Attachments

  • Taxt extracttion single cell to multiple cells.xlsx
    12.4 KB · Views: 7
Maybe flash fill can be used.
Make sure you cover all scenarios in the examples you put in. Then highlight the full column and press CTRL+E. Repeat per extraction.
It's often a faster way for one shot analysis than writing formulae.
I'm without Excel and can't open your sample file, so appologies if the tip turns out to be very bad advice.
 
Hi Juniad,
Please check if this works for the first part (English Name) with your data:
=LEFT(A3,MIN(IF(CODE(MID(A3&REPT(" ",200),ROW($A$1:$A$200),1))=63,ROW($A$1:$A$200),201))-1)

This is an array formula so needs to be committed by using CTRL+SHIFT+ENTER
 
Back
Top