LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 53
Default Splitting Data

I have multiple cells within a column that contain text and numbers. I need
to split out the numbers. I don't think Data Text to Columns will work
because the numbers do not line up. Below is an example. Can anyone save me
from having to manually enter these numbers??

Virtualizer for Capacity on Demand - 38756
Virtualizer for High Availability - 38758
Marimba OS Management - 38759
BootManage Administrator by Bootix - 38663

 
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
splitting data Windy Excel Discussion (Misc queries) 1 January 23rd 08 02:28 AM
Splitting data in cells Catracho4444 Excel Discussion (Misc queries) 2 October 20th 07 01:04 PM
splitting data across worksheets newshoes Excel Discussion (Misc queries) 3 November 13th 06 05:19 PM
Splitting data in a cell JamesBurrows Excel Discussion (Misc queries) 9 June 13th 06 05:06 PM
Splitting Data jez123456 Excel Worksheet Functions 4 March 4th 05 09:38 AM


All times are GMT +1. The time now is 01:16 PM.

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"