I will be receiving CSV's with a lot of info in each cell but I need the first number that appears in the cell. Is there a way to extract the first number automatically without having to select each one manually? Here's an example...
Here I would need the number 147.23
josh;smith;147.23;2;0;371;
Hi Billznik,
The easiest way would be to select the data and then split it by semi-colon using the Data > Text to Columns menu option (Excel 2003) then deleting any columns you don't want.
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Perfect, thanks!
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks