Parse out into 2 separate fields

Question

Attached is my screen shot of work.  I have to parse out the account information into two fields, account number and name. I have the sort tool and the Regular Expression tool and will use the multi row formula tool.  I am a beginner and do not know which tool to use first. And how to parse out and separate into two fields.  Please help if you can! Thank you.

Screenshot (15).png

Prometheus · Answer

@freinerd You spelled account with one "c." When you're typing in expressions in to the Formula tool or the Filter tool, it might help you to type in a left square brace (like this --> [) and then type in a letter. All the available fields will appear in a dropdown menu form for you to either click on to pick, or if what you want is at the top of the menu, just hit tab and it will populate your expression window with the field you chose. This is helpful, especially when typing in complex or nested formulas.

freinerd · Answer

Hello!  And thank you for the sample file attached.  When I use the Formula Tool, I am getting a parse error.  I may have the formula typed in wrong.  But the word Account seems to be a problem- not sure.  I will attach a screenshot and also the first page of the excel file. Thank you so much, I am finding your suggestions helpful.  This is the first time I have typed in a formula!

Screenshot (17).png

Screenshot (10).png

freinerd · Answer

Thank you for the link to RegEX!  This is very helpful1