Separate numbers in different columns by a formula

[Closed]

Report

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
Excel formula to find similar text in two columns - How-To - Excel
Apply formula to entire column excel - How-To - Excel
Trying to create a multi-column formula. ✓ - Forum - Excel

Separate numbers in different columns by a formula

Your reply

Subscribe To Our Newsletter!