LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default seperate numbers in a cell

If I've got a cell with a 12 digit number it it (123456789123). Is i
possible to take that number and place each digit into its own cell?
1 goes to D6
2 goes to E6
etc...

Thank you

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add two cells from seperate work sheets into a cell on seperate wo lar Excel Worksheet Functions 6 April 27th 10 06:54 PM
Seperate Alphabet and numbers in a cell Kshitij Excel Discussion (Misc queries) 7 September 10th 08 10:38 AM
How can I seperate numbers from text (in one cell) into 2 cells? LinLin Excel Discussion (Misc queries) 2 February 14th 08 10:14 PM
Adding numbers in one cell and showing total in seperate cell Deernad Construction Excel Discussion (Misc queries) 12 November 29th 05 07:32 PM
SEPERATE NUMBERS IN A CELL lehigh46 Excel Worksheet Functions 8 June 17th 05 12:22 AM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"