All, I have to separate a 6 digit number in 1 cell into 6 individual cells per row. Example.
123456 (A1) and need to be (A1 is 1, B1 is 2, C1 is 3, D1 is 4 etc.
Row 2 might be 568914 so I need row to to be (A2 is 5, B2 is 6, C2 is 8, D2 is 9, E2 is 1 and F2 is 4).
I have 1500 rows of current numbers and need to separate like i have explained.
I hope this makes sense to you all.
Michael
Take a look to TEXT to COLUMNS option.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
=MID($D4,COUNTA(D4:$D4),1)
See attachment for example. Hopefully that will show you how to adapt the formula for your own worksheet.
__
How To Mark Your Thread Solved
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
Last edited by GeneralDisarray; 06-03-2013 at 10:07 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
[SOLVED]
Outstanding. Certainly Appreciate it.
Originally Posted by GeneralDisarray
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks