Remember Me?

#### Menu

#1
October 19th 06, 11:38 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2006 Posts: 82
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
October 19th 06, 06:21 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 5,441
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
October 21st 06, 12:16 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2006 Posts: 117
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
October 25th 06, 06:31 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2006 Posts: 82
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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Reddiance Excel Discussion (Misc queries) 2 April 18th 05 06:03 PM dwalsh77 Excel Discussion (Misc queries) 0 April 8th 05 05:29 PM Pat Mayton Excel Worksheet Functions 2 March 24th 05 03:37 PM Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM cflores Excel Discussion (Misc queries) 0 January 23rd 05 06:45 AM

All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017