• 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&Numbers

zeldy

New Member
HOW DO I SEPARED TEXT AND NUMBER
40001 Income from Service
40002 Sales of Products Income
40005 Lease Income
41001 Services
41003 Shipping Income
42000 Discounts given
Total Income
Cost of Goods Sold
50000 Cost of Products
50001 Construction Materials Costs
50005 Travel Expenses for Project - COGS
50006 Cost of Services
50008 Freight & Shipping cost
50099 Inventory Shrinkage
51000 Warehouses Supplies & Services
61220 Storage Rental - COGS
61231 Depreciation Expenses
66071 Gross Salaries - S&S COGS
66072 Employer Taxes - COGS
Total Cost of Goods Sold
Gross Profit
Expenses
Finance Expenses
69000 Bank Charges & Fees
Total Finance Expenses
General & Administrative Expenses
61001 Computers & Supplies
61004 Donation
61005 Dues & Subscriptions
61008 Meals & Entertainment
61010 Office & Supplies Expenses
61012 Postage
61021 Corp.Annual Report Fees
61022 NJ Annual Report Services
61023 Licenses & Permits
61024 Staff Incentives - Gift
61099 Equipment & Hardware
61200 Rent or Lease of Buildings
61233 Depreciation
64002 Travel Expense - GA & Other Dpt
66050 Gross Salaries - G & A
66051 Employer Taxes- G&A
Total General & Administrative Expenses
Insurance Expenses
63300 Prof.&General Liability Insurance
63301 Insurance - WorkersComp
Total Insurance Expenses
Interest Paid
Other Business Expenses
Research & Development
65004 Travel Expense - R & D
65006 Testing & Research
65008 Conferences & Seminars
65009 Salaries & wages - R & D
65010 Employer Taxes - R & D
Total Research & Development
Total Other Business Expenses
Payroll Expenses
65003 Employee Benefits
65005 Retirement Plan
Total Payroll Expenses
Professional Services
61003 Consulting Fees
61006 Legal Fees
61016 Accounting & Bookkeeping
66999 Payroll Processing fees
Total Professional Services
Sales & Marketing Expense
62003 Advertising Expense
62004 Membership & Conferences
62007 Uniforms & Customized Safety Gear
64001 Travel Expense - S & M
64004 Accomodation
66001 Salaries & Wages - S & M
66002 Employer Taxes - S & M
67002 Subcontractor Expense
Total Sales & Marketing Expense
Total Expenses
Net Operating Income
Other Income
80000 Late Fee Income
80002 Interest Earned
Total Other Income
Other Expenses
65001 States Payroll Taxes
65002.1 State Income Tax
65007 Federal Income Tax
Total Other Expenses
Net Other Income
Net Income
 
zeldy
Please, use capital letters as those should use... eg the 1st letter of sentence.
Okay, You sent sample data ...
... but ...
... hmm?
You do not expect anything ... or where are those expected results?
 
Is the attached in sheet Table what you are looking for? If so, then use Power Query to split as shown. Click on Data, connections to view M code
 

Attachments

  • EXAMPLE.xlsx
    21.7 KB · Views: 6
Try this formula in B3 with Ctrl + Shift + Enter
=SUM(MID(0&A3,LARGE(ISNUMBER(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1))*ROW(INDIRECT("1:"&LEN(A3))),ROW(INDIRECT("1:"&LEN(A3))))+1,1)*10^(ROW(INDIRECT("1:"&LEN(A3)))-1))

And in C3
=TRIM(SUBSTITUTE(A3,B3,""))

See the sample sheet as well.
 

Attachments

  • EXAMPLE.xlsx
    15.2 KB · Views: 3
Last edited:
Or using the modern dynamic array functions, it might be

Code:
=BYROW(A2:A92;
LAMBDA(_r;
LET(_t;INDEX(TEXTSPLIT(_r;" ";;TRUE;);1);
IF(ISNUMBER(_t+0);_t;"") ) ) )

PS: Only posting it since I'm forcing myself to use these and start to learn those new functions.
 

Attachments

  • EXAMPLE.xlsx
    12.6 KB · Views: 5
Back
Top