| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
separating multiples digit in a cell into individual cell
Hi,
Go to the Data menu and in the, under Data Tools you will see Text to columns -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sierra spiegel" wrote in message ... And how do you do data text? Ashish Mathur wrote: Hi,Use Data Text to columns and specify the delimiter as 17-Nov-09 Hi, Use Data Text to columns and specify the delimiter as space -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sierra spiegel" wrote in message Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Essential ASP.NET 2.0 [Addison-Wesley] http://www.eggheadcafe.com/tutorials...net-20-ad.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to separate text and numbers in one cell or column? | Excel Worksheet Functions | |||
| summing 2 to 8 separate numbers in a single cell | Excel Worksheet Functions | |||
| How to separate numbers and alphabate from a cell | Excel Discussion (Misc queries) | |||
| how do i separate numbers and text in a cell? | Excel Discussion (Misc queries) | |||
| How to separate the numbers and characters in the cell | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
