| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing data from cell within an excel spreadsheet
Ron
Again, many thanks - that also worked. Regards Dawn "Ron Rosenfeld" wrote: On Mon, 20 Feb 2006 02:31:34 -0800, "Dawn" wrote: Ron Could you also let me know the formula to use to so I can extract the christian name from the column. Many thanks Dawn Try this: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE( A1," ",CHAR(1),LEN(A1)-LEN( SUBSTITUTE(A1," ",""))))-1) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get data from one excel spreadsheet to another | Excel Discussion (Misc queries) | |||
| MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| When entering data into excel spreadsheet cell, the page just jump | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
