| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
JE McGimpsey wrote...
One way: =LEFT(TRIM(A1),3)&IF(ISERR(FIND(" ",TRIM(A1))), "", MID(TRIM(A1),FIND(" ", TRIM(A1))+1,2) & IF((LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ","")))1, MID(TRIM(A1), FIND("^",SUBSTITUTE(TRIM(A1)," ","^",2))+1,1),"")) .... And another (a little redundancy goes a long way, or should that be a short way), =TRIM(LEFT(TRIM(A1),3)&MID(TRIM(A1),FIND(" ",TRIM(A1)&" ")+1,2) &MID(TRIM(A1),FIND(" ",SUBSTITUTE(TRIM(A1)," ","",1)&" ")+2,1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a grading system in Office Excel? | New Users to Excel | |||
| create a data entry form template in Excel 2003? | Excel Discussion (Misc queries) | |||
| Create invoices from excel workbook | Excel Worksheet Functions | |||
| How do I create a geographic map in Excel 2003? | Excel Worksheet Functions | |||
| Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel | |||
Hybrid Mode
