How to transfer data from single cell to multiple cells?
Hello everyone,
I'm new here, and I hope someone could enlighten me on my current problem.
We have currently have a project where we need our data placed from a single cell (see: orange highlighted cells) to multiple cells (see: yellow highlighted cells). The data are numbers.
Please see screenshot: Here
Thank you.
Here, try this:
=MID($A1, COLUMNS($A$1:A1), 1) and pull right
Last edited by zbor; 05-11-2010 at 09:34 AM.
=--LEFT(TEXT($B$3,"0000000"),COLUMN()-1)
copied across!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks