how do i separate cell value in four different cells?

S

sit

As an example A1 = 250.50 and must be shown as B2-2, C2-5, D2-0, E2-5
F2-0

Please help
Thank Yo
 
R

Ron de Bruin

Hi Sit

Try this

copy in B2 this formula
=MID($A$1,COLUMN(A:A),1)
copy this formula to the right
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing 2 cells using vlookup 4
Average problem 1
Help Writing a SUM Formula 5
b;ank cells in calculations 2
Splitting Numbers into Columns. 3
how do i separate cell value in four different cells? 1
Merged cells 1
Formula autofill to cells below – formula arguments are cell areas in different columns 1

Top