LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
caloy
 
Posts: n/a
Default help with excel number string

I have a string of numbers, 25 characters long which is in a cell. Iam
looking to find a function/solution so that I can place each individual value
within the string into individual cells.

Ex.
131112213111231111223311 - this string is in cell A1
I want to distribute each number into individual cells (ex. B1 through AA1)
--
Caloyski
 
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
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Change number when you open the excel template mowen Excel Discussion (Misc queries) 3 October 18th 05 08:05 PM
Access Excel Linked Text and Number Issues Scott Excel Discussion (Misc queries) 2 October 4th 05 09:24 PM
Excel not taking number format consistently KP Conrad Excel Discussion (Misc queries) 1 September 22nd 05 07:37 PM
Can the number of times undo is used in Excel 2002 be increased? Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 05:54 PM


All times are GMT +1. The time now is 06:49 AM.

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

About Us

"It's about Microsoft Excel"