|
|
#1
03-17-2016, 01:19 PM
|
|||
|
|||
Separating elements of data in a cell
Am familiar with LEFT, RIGHT, MID and Text to Columns, but none seem to answer my need. Here are several example numbers:
S805602 SA7515 SA11-901 SFV72-737-2 SAE4406 My need is to go to the first "number" and retrieve the first 2 "numbers" as these specify location within the plant. As the position of the first number is variable the above formulae do not work.........at least as far as I can determine. Thank you for any assistance. 
|
| Tags |
| data, elements, parse |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
| 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 |
 Separating Name, Birthday, email, address, etc that is in one cell
|
ABreyen | Excel | 1 | 07-01-2015 05:11 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 |
Windows 10 
Office 2016
Threaded Mode