how do i separate cell value in four different cells?

  • Thread starter Thread starter sit
  • Start date Start date
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
 
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

Merging rows based on column value 2
Average problem 1
Comparing 2 cells using vlookup 4
Automatically fill in TRUE values 2
Time Sheet - Calculating Time Differences for Totals 3
b;ank cells in calculations 2
Populate cell is another cell is populated 2
Splitting Numbers into Columns. 3

Back
Top