Separate numbers in different columns by a formula

Closed

azam - Sep 26, 2014 at 07:26 AM

Hello,

I want to separate numbers in different columns by formula.
For example: in Cell (A1) having number 106,504.00 separate in different cells by transfer 100,000, 6,000, 500 and 4 in four different cells. (number in Cell A1 separate in 4 different columns.

Separate numbers in different columns by a formula
Excel conditional formatting formula based on another column ✓ - Forum - Excel
Excel – Formula to calculate between two columns - How-To - Excel
Delete duplicates in Excel: column, formula - Guide
Excel formula to find similar text in two columns - Guide
Copy column from one sheet to another in excel using formula - Guide

Subscribe To Our Newsletter!