How to Split First Name and Last Name from Full Name

These vital minerals (especially calcium) can then end up in your blood vessels, your brain, your kidneys, inside your joints and a myriad of other inconvenient places. online prescription viagra without What appears to be good and effective for others might not be visit over here cheap viagra good and effective for you. It just helps you in getting the sildenafil online india http://deeprootsmag.org/2015/08/03/after-30-bizarro-years-dan-piraro-is-goingsomewhere-else-maybewho-knows/ erection for long enough to complete the act. Here, the product is being produced in bigger quantities than wheat sildenafil online india or even corn.


How to Split First Name and Last Name from Full Name

Sometime we have only one field for a full customer name, do not have a separate field for first name and last name. In the picture below, it is a list of customer full name.

customer name

If we want to extract a first name and last name from this full name of customer name, we can use the Left Function and Mid Function with InStr function inside the Left and Mid Function. We can create a new field for FirstName and LastName in the query by using Left and Mid function as shown in the picture below.
query for firstnameget firstname and lastname

Note:

Left Function: Returns a Variant (String) containing a specified number of characters from the left side of a string. Syntax : Left (anystring, number of character from the left side of string)
This example uses the Left function to return a specified number of characters from the left side of a string.

Dim strText, MyStr
 strText = "Hello World" ' Define string.
 MyStr = Left(strText, 1) ' Returns "H".
 MyStr = Left(strText, 7) ' Returns "Hello W".

More Info about Left function at: https://support.office.com/en-za/article/Left-Function-d5897bf6-91f5-4bf8-853a-b63d7de09681

InStr Function: Returns a Variant (Long) specifying the position of the first occurrence of one string within another.

More Info about InStr function at : https://support.office.com/en-us/article/InStr-Function-85D3392C-3B1C-4232-BB18-77CD0CB8A55B

Mid Function: Returns a Variant (String) containing a specified number of characters from a string.
More info about Mid Function at : https://support.office.com/en-sg/article/Mid-Function-427e6895-822c-44ee-b34a-564a28f2532c

Related posts