I was wondering if it was possible for excel to read information posted in one cell and put it into multiple cells.
My example: I copy and past the temperatures in cell a1... they are in Monday 50 Tuesday 45 format. Cells b1-b7 would consist of the days of the week... b1 monday b2 tuesday and so on. Woud it be possible for excel to read the data... as in it reads monday 50 from cell a1 and puts the 50 in cell c3.. reads the tuesday 45 in cell a1 and pasts the 45 in cell c2. and so on.
This is just an example.. and im working on something more complex.. but this feature would make things so much easier.
Is it possible and if so how do I set it up?
Thanks in advance
Bookmarks