Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting First Name from cell with first name and last name
I have searched several posts and am still stumped. I have a first
name and last name in Cell B10 on Sheet1. I want to extract the first name with no spaces. It is part of a bigger code where I am opening outlook and making an email. The end result is to use the person's first name in the saluation. I have all the code to do everything except that I can't figure out how to grab the first name. Any help would be greatly appreciated. Thanks in advance. Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting First Name from cell with first name and last name
You probably want this...
=LEFT(A1,FIND(" ",A1&" ")-1) but be advised that it (and most other solutions) will return the wrong result for people whose first name has a space in it (such as Mary Ann). -- Rick (MVP - Excel) "Matt" wrote in message ... I have searched several posts and am still stumped. I have a first name and last name in Cell B10 on Sheet1. I want to extract the first name with no spaces. It is part of a bigger code where I am opening outlook and making an email. The end result is to use the person's first name in the saluation. I have all the code to do everything except that I can't figure out how to grab the first name. Any help would be greatly appreciated. Thanks in advance. Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting First Name from cell with first name and last name
Whoops! You wanted this in VB code, right? Sorry, try this...
FirstName = Split(Range("B10").Value)(0) -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... You probably want this... =LEFT(A1,FIND(" ",A1&" ")-1) but be advised that it (and most other solutions) will return the wrong result for people whose first name has a space in it (such as Mary Ann). -- Rick (MVP - Excel) "Matt" wrote in message ... I have searched several posts and am still stumped. I have a first name and last name in Cell B10 on Sheet1. I want to extract the first name with no spaces. It is part of a bigger code where I am opening outlook and making an email. The end result is to use the person's first name in the saluation. I have all the code to do everything except that I can't figure out how to grab the first name. Any help would be greatly appreciated. Thanks in advance. Matt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting First Name from cell with first name and last name
You are right there is a space. For instance, if the name was United
States, there would be a space in between the name. I ran your vba text, but it is only bringing in the first letter of the first word - "U". Am I missing something? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting First Name from cell with first name and last name
If your data is well formatted, you might try something like (untested):
left(namestring,find(" ",namestring)) I don't recall offhand, you might have to shorten the length by 1 to not include the space itself, e.g. left(namestring,find(" ",namestring)-1) This only works if you have single first names and single last names. If your data includes some with prefixes (Dr, Mrs, etc.) or two-word first names "Carol Anne Carpenter" then this solution isn't likely to be sufficient without additional data cleaning. HTH, Keith "Matt" wrote: I have searched several posts and am still stumped. I have a first name and last name in Cell B10 on Sheet1. I want to extract the first name with no spaces. It is part of a bigger code where I am opening outlook and making an email. The end result is to use the person's first name in the saluation. I have all the code to do everything except that I can't figure out how to grab the first name. Any help would be greatly appreciated. Thanks in advance. Matt . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting First Name from cell with first name and last name
FirstName = Split(Range("B10").Value)(0)
I ran your vba text, but it is only bringing in the first letter of the first word - "U". Am I missing something? That is not possible... unless there was a space between the "U" and the "n" or unless you Dim'med the FirstName variable like this... Dim FirstName As String * 1 which I think would be highly unlikely. Show us the code you are using (not just my one-liner, but the code procedure you have it in). -- Rick (MVP - Excel) "Matt" wrote in message ... You are right there is a space. For instance, if the name was United States, there would be a space in between the name. I ran your vba text, but it is only bringing in the first letter of the first word - "U". Am I missing something? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting data from one cell to another | Excel Worksheet Functions | |||
Extracting from a cell | Excel Discussion (Misc queries) | |||
Extracting data from a cell | Excel Discussion (Misc queries) | |||
Extracting hyperlink from a cell | Excel Worksheet Functions | |||
extracting a string from a cell | Excel Programming |