| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Put in B1: =LEFT(A1,SEARCH(" ",TRIM(A1))-1)+0
Put in C1: =MID(A1,SEARCH(" ",TRIM(A1))+1,99) Slight revision to above. Use instead: In B1: =LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1)+0 In C1: =MID(TRIM(A1),SEARCH(" ",TRIM(A1))+1,99) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| Creating a specific formula | New Users to Excel | |||
| Creating a formula using absolute referencing - I think!! | Excel Worksheet Functions | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
