Formula Extract the given name from unwanted space

[Amit Rawat]

I want extract the given name in both two conditions.

1st condition there is some extra space before the given name and the second condition is no extra space. And I need the same formula for both the conditions.

[=Arun Kumar1993]

Use trim function..TRIM function returns a text value with the leading  and trailing spaces removed. You can also use the TRIM function to remove unnecessary spaces between words in a string.

[Amit Rawat]

Use trim function..TRIM function returns a text value with the leading  and trailing spaces removed. You can also use the TRIM function to remove unnecessary spaces between words in a string.

Hi Arun,

I know the Trim function but i think you haven't seen the question properly.

My question was to remove the extra space before the given name and i need that formula which commonly work for both the conditions.

Request you to please attach the file with solutions..

[=Arun Kumar1993]

As per my understanding . I think you want to extract first name in both condition when the extra space given before the name and the 2nd one is no space given before the name.
if your question is that so this formula will help you.

=LEFT(TRIM(A2),FIND(" ",TRIM(A2))-1)
 here A2 is your text

[Amit Rawat]

As per my understanding . I think you want to extract first name in both condition when the extra space given before the name and the 2nd one is no space given before the name.
if your question is that so this formula will help you.

=LEFT(TRIM(A2),FIND(" ",TRIM(A2))-1)
 here A2 is your text



Thanks, it is working

[Deepaksingh]

I want extract the given name in both two conditions.

1st condition there is some extra space before the given name and the second condition is no extra space. And I need the same formula for both the conditions.

Hi Amit bro  ,

I was just simply checking all queries, I found your old one and I tried to solve with a new way.

kindly check and suggest m, its is correct or not.

Thanks
Deepak Singh

[Amit Rawat]

I want extract the given name in both two conditions.

1st condition there is some extra space before the given name and the second condition is no extra space. And I need the same formula for both the conditions.

Hi Amit bro  ,

I was just simply checking all queries, I found your old one and I tried to solve with a new way.

kindly check and suggest m, its is correct or not.

Thanks
Deepak Singh

Yes Deepak it is absolutely fine.
you are champ Man..!!

[devendra_dev20]

I want extract the given name in both two conditions.

1st condition there is some extra space before the given name and the second condition is no extra space. And I need the same formula for both the conditions.

Hi,

I could not understand your question.
Please explain your question in excel sheet with desire output in front of raw output.

Please also check attached sheet.
Thanks
Devendra Adhikari