| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use the first word only
Hi
I have Excel 2003 SP2 I have a column with product names, the column is 4,000 rows long. The products are between three and seven words long but I only need the first word, how do I extract the first word only. thanks Daniel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use the first word only
Try this...
A1 = try this out =LEFT(A1,FIND(" ",A1)-1) Returns: try -- Biff Microsoft Excel MVP "Daniel - Sydney" wrote in message ... Hi I have Excel 2003 SP2 I have a column with product names, the column is 4,000 rows long. The products are between three and seven words long but I only need the first word, how do I extract the first word only. thanks Daniel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use the first word only
Put in an auxilary column in Row 1 and copy down through all rows
=LEFT(A1,FIND(" ",A1)-1) "Daniel - Sydney" wrote: Hi I have Excel 2003 SP2 I have a column with product names, the column is 4,000 rows long. The products are between three and seven words long but I only need the first word, how do I extract the first word only. thanks Daniel |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use the first word only
Thanks to Joel and T. Valko
"T. Valko" wrote: Try this... A1 = try this out =LEFT(A1,FIND(" ",A1)-1) Returns: try -- Biff Microsoft Excel MVP "Daniel - Sydney" wrote in message ... Hi I have Excel 2003 SP2 I have a column with product names, the column is 4,000 rows long. The products are between three and seven words long but I only need the first word, how do I extract the first word only. thanks Daniel |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use the first word only
You're welcome!
-- Biff Microsoft Excel MVP "Daniel - Sydney" wrote in message ... Thanks to Joel and T. Valko "T. Valko" wrote: Try this... A1 = try this out =LEFT(A1,FIND(" ",A1)-1) Returns: try -- Biff Microsoft Excel MVP "Daniel - Sydney" wrote in message ... Hi I have Excel 2003 SP2 I have a column with product names, the column is 4,000 rows long. The products are between three and seven words long but I only need the first word, how do I extract the first word only. thanks Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
| Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
| Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
| how do i link a word to a colour so everytime i type the word gre. | Excel Discussion (Misc queries) | |||
Linear Mode
