Assignment 18 String Function String Question

Assignment 18

String Function

String Question

Function Used

LEFT :- Left function extract a given number of character from left side.

MID :- This function gives number of character from the middle of text.

SEARCH:- This function use to find specific text in a string and give the number of location in string.

FIND :- This function have work same as search function.

LOWER :- The lower function return a lower -case version of a given string.

Function for "Gender"

=IF(LEFT(D5,"3")="Ms.","Female","Male")

If the name is equal to "Ms." than it will return "Female" otherwise "Male".

Function for "First Name"

=IFERROR(MID(D5,SEARCH(" ",D5,1)+1,SEARCH(" ",D5,1)),RIGHT(D5,LEN(D5)-FIND(" ",D5)))

This function return the first name of full name entries in that table. it extract the first name of string.

Function for "Last Name"

=IFERROR(RIGHT(D5,LEN(D5)-FIND(" ",D5,FIND(" ",D5,1)+1)),RIGHT(D5,LEN(D5)-FIND(" ",D5)))

This function return the last name of full name entries in that table.

Function for "Email ID"

=IFERROR(LOWER(LEFT(RIGHT(D5,LEN(D5)-FIND(" ",D5,FIND(" ",D5,FIND(" ",D5,1)+1))&LOWER(MID(D5,SEARCH(" ",D5,1)+1,SEARCH(" ",D5,SEARCH(" ",D5,1)+1)-SEARCH(" ",D5,1))),LOWER(RIGHT(D5,LEN(D5)-FIND(" ",D5))))&" . "&C5&"@ABCmail.Com"

It return the email id according to name when we enter name then Email ID print . it based on name.

Note :-

This ia simple question in which you have to insert some string related function in the different criteria.

1. you have to print the gender of every name in gender's column.

2. Print the first name of every students.

3. Print the last name of every students.

4. Create a Email ID in the last column named as Email ID the criteria of email id it should be combination of first letter of last name then first name then " . " then sn. "@ABCmail.com"

There are some thing you should keep in mind that you can use any function which you thing that suitable for this question.

Always think about case and space while solving that type of question.