| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
separate a Capital starting word from a sentence
I have a sentence in cells of column A.
Sentence starts with a capital word and the next word starts with capital but the rest is small. I want to separate the first total capital word from the rest. How can I do this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate a Capital starting word from a sentence
Rasoul,
For a string in cell A1: =LEFT(A1,FIND(" ",A1)-1) =MID(A1,FIND(" ",A1)+1,LEN(A1)) HTH, Bernie MS Excel MVP "Rasoul Khoshravan" wrote in message ... I have a sentence in cells of column A. Sentence starts with a capital word and the next word starts with capital but the rest is small. I want to separate the first total capital word from the rest. How can I do this. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate a Capital starting word from a sentence
Mr. Rasoul - try to place a space " " between the first and the second word
of the sentence. Or u can give me what sentence is it ? "Bernie Deitrick" wrote: Rasoul, For a string in cell A1: =LEFT(A1,FIND(" ",A1)-1) =MID(A1,FIND(" ",A1)+1,LEN(A1)) HTH, Bernie MS Excel MVP "Rasoul Khoshravan" wrote in message ... I have a sentence in cells of column A. Sentence starts with a capital word and the next word starts with capital but the rest is small. I want to separate the first total capital word from the rest. How can I do this. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate a Capital starting word from a sentence
They have space between two words.
Bernie Deitrick solution, solved my problem. "romelsb" wrote in message ... Mr. Rasoul - try to place a space " " between the first and the second word of the sentence. Or u can give me what sentence is it ? "Bernie Deitrick" wrote: Rasoul, For a string in cell A1: =LEFT(A1,FIND(" ",A1)-1) =MID(A1,FIND(" ",A1)+1,LEN(A1)) HTH, Bernie MS Excel MVP "Rasoul Khoshravan" wrote in message ... I have a sentence in cells of column A. Sentence starts with a capital word and the next word starts with capital but the rest is small. I want to separate the first total capital word from the rest. How can I do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
| Separate last word in cell with more than 2 words? | Excel Worksheet Functions | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Linear Mode
