Previous Topic Next Topic

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.


Related:

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
VBA find column by name and sort
SidK -
bOFILL -

4 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Use of '@' in formulae
Quarterp -
Quarterp -

6 responses