answersLogoWhite

0

There are ways of doing this, but there are complications which mean it can't always work, but first let's look at how to do it. Say you have the name as follows:

Peter Colgan

What you do here is to find where the space is. Once you've located the space, then you take the text up to it and extract it and cut the rest of the cell out and extract it. To find the space, you use the Find function. So say the text is in A1, then the formula to find the space is:

=Find(" ",A1)

That will give you a number, representing the location of the space, in this case 6. Now what you can do is get the first 6 characters from the left of the cell, which can be done like this:

=left(A1,6)

That will get you Peter and the space. To do it in one go, you would put the Find formula into the Left formula, noting that there are 2 brackets at the end.

=Left(A1,Find(" ",A1))

To get from the space onwards, for the surname, you would use the MID function, which takes text from a cell starting at a set point, for a set amount of characters. Using the Find function again, it would be as follows:

=MID(A1,Find(" ",A1),10)

The 10 there will get the next 10 characters from the space onwards. To be accurate you need to know how long the text will be. You can use the LEN formula, which gets the length of the text in a cell minus where you found the space. So you could have this:

=MID(A1,FIND(" ",A1),LEN(A1)-FIND(" ",A1))

This will work for you, but there is one problem. If someone has a double-barrelled name, there is no way to tell the computer which is the surname. So if you applied the above to "James Patrick Doyle" then it will take the surname as starting from the first space and not the second one, giving "Patrick Doyle" as the surname and not "Doyle". So there is no 100% way of doing it.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How would you extract zinc from a zinc containing mineral?

to extract zinc from its mineral you can heat it with carbon


How much metal could you extract from 1000g of an ore containing 1 percent metal?

You would be able to extract 10g of metal from 1000g of an ore containing 1 percent metal. This is calculated by taking 1 percent of 1000g.


What is name of a solution or preparation containing the active agents of a drug plant juice etc?

Extract


What is extract volcanoes?

extract volcanoes are what makes a volcano a volcano involve CA and CA (cait and cameron) the volcano will be complete


How much metal could you extract from 1000 g of an ore containing 1 percent of metal?

From 1000 g of ore containing 1 percent metal, you would be able to extract 10 g of metal. This is calculated by taking 1 percent of 1000 g.


What are the potential health benefits of consuming products containing gooseberry extract?

Consuming products containing gooseberry extract may offer potential health benefits such as improved digestion, boosted immune system, and enhanced skin health due to its high antioxidant content and vitamin C.


Can you extract stem cells from a dead body?

Yes, it is possible to extract tissue-specific stem cells post mortem.


What is the function of beef extract in media?

Beef Extract Powder is prepared and standardized for use in microbiological culture media, where it is generally used to replace infusion of meat. Culture media containing Beef Extract Powder are recommended for use in bacteriological examination of water, milk, and other materials, where uniform composition of media is important. Beef Extract Powder is relied upon for biochemical studies, particularly fermentation reactions because of its independence from fermentable substances. Several media containing Beef Extract Powder are recommended in standard methods for multiple application.


Potato extract plus sodium azide plus catechol plus H2O2?

this cannot be answered without specific reference to the particular extract in question.


How can I use ffmpeg to extract a specific frame from a video file?

To extract a specific frame from a video file using ffmpeg, you can use the command: ffmpeg -i input.mp4 -vf "selecteq(n,framenumber)" -vsync vfr output.jpg Replace input.mp4 with the name of your video file, and framenumber with the specific frame number you want to extract. This command will save the extracted frame as output.jpg.


What is the password for runescape pin generator to extract?

An accounts pin is specific to your account.


What effects does golden seal extract have on urine containing THC?

Absolutely nothing. Goldenseal is a myth, based on a mystery novel, it doesn't work.