|
|
#1
10-07-2015, 03:05 AM
|
|||
|
|||
Data extraction from a cell!
Hi guys, I've been at this all morning and had numerous attempts. Please help  Basically, in single cellsI receive data in this format: 25km 50m 3km 700m ..... In order for me to do my relevant calculations, I need to split them into numbers only. For example: kilometreage km m 25km 50m 25 50 3km 700m 3 700 Please see attached attempts for where I'm at. Thanks i advance  JT
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
| Copying data from one cell to another where condition is third cell | fairyca | Excel | 4 | 03-30-2014 08:22 AM |
| How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
 Bibliography creation and automatic extraction
|
styxsailor | Word | 3 | 11-30-2012 02:42 PM |
|
Email Extraction
|
dpad | Outlook | 1 | 08-17-2010 06:01 PM |
Windows 7 32bit 
Office 2013
Threaded Mode