• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Extract the given name from unwanted space
#1
Basket 
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. Smile


Attached Files
.xlsx   Given Name.xlsx (Size: 9 KB / Downloads: 23)
  Reply
#2
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. Smile
  Reply
#3
(06-Jul-2018, 12:16 AM)=Arun Kumar1993 Wrote: 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. Smile



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..
  Reply
#4
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


Attached Files
.xlsx   Given Name.xlsx (Size: 9.7 KB / Downloads: 9)
  Reply
#5
(08-Jul-2018, 12:22 AM)=Arun Kumar1993 Wrote: 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
  Reply
#6
(05-Jul-2018, 08:14 PM)Amit Rawat Wrote: 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. Smile
Hi Amit bro  Tongue ,

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


Attached Files
.xlsx   Extract first name with space.xlsx (Size: 9.68 KB / Downloads: 11)
  Reply
#7
(27-Aug-2018, 08:49 PM)Deepaksingh Wrote:
(05-Jul-2018, 08:14 PM)Amit Rawat Wrote: 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. Smile
Hi Amit bro  Tongue ,

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..!! Smile
  Reply
#8
(05-Jul-2018, 08:14 PM)Amit Rawat Wrote: 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. Smile

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


Attached Files
.xlsx   Resolved_Given Name.xlsx (Size: 9.4 KB / Downloads: 1)
  Reply


Related Topics
Topic Author Replies Views Last Post
  Data Filtering Extract Email ID @m!t $@!n! 1 1,139 12-Sep-2019, 12:13 AM
Last Post: sourabh sharma
  Data Filtering Query: Mid & Search Function: Extract Data @m!t $@!n! 3 2,188 27-Aug-2018, 01:10 AM
Last Post: @m!t $@!n!
  Formula Convert Text Into Value & Remove Space @m!t $@!n! 2 1,893 21-Aug-2018, 11:47 AM
Last Post: devendra_dev20
  Data Filtering Query: Vlookup: Extract Number From Data @m!t $@!n! 3 2,297 10-Aug-2018, 10:53 PM
Last Post: @m!t $@!n!
  Formula Space in any text or numeric data Vinay Singh 4 2,363 06-Jun-2018, 04:43 PM
Last Post: Abhishek Jain
  Formula Extract Text and Numeric Sanjeev Gupta 1 1,830 01-Mar-2018, 10:39 PM
Last Post: Lovedeep sharma
  Formula Extract the data month wise as single entry Dharmesh Kumar Srivastava 2 2,099 01-Dec-2017, 11:12 AM
Last Post: Dharmesh Kumar Srivastava
  Formula Extract the Word Amit Dhankar 1 1,894 12-Sep-2017, 04:34 PM
Last Post: Lovedeep sharma
  Formula Extract word with Search Function Amit Dhankar 1 1,855 14-Aug-2017, 11:24 PM
Last Post: Lovedeep sharma
  Formula How to Extract date in text every cells Mohit Sharma 2 2,650 01-Jun-2017, 09:18 PM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)