Extracting First Name from cell with first name and last name
in [Programming]
|
Prev: Open VBA Editor?
Next: Select the UNIQUE vendors name
From: Rick Rothstein on 23 Apr 2010 19:48 > 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" <mattsonnier(a)gmail.com> wrote in message news:4112c98b-a623-46d3-b8cd-eee0d3872bd0(a)z7g2000yqb.googlegroups.com... > 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? |