Fill Textbox from cell

Hi,
I need to fill two textboxes on a userform with information from one cell.
In Range ("ClientName") is text "Last, FirstName". I need to fill Textbox1
with "LastName" and Textbox2 with the "FirstName". I have no problem
filling the textbox with the entire text from the cell, but I have no idea
how to split the information at the comma. The only information I could
find suggested using the Left function, but since the number of characters
can vary that didn't work too well. Any help would be greatly appreciated.
Thanks
Valerie

Valerie

Try this: for last name =LEFT(ClientName,FIND(", ",ClientName)-1)
and for first name =RIGHT(ClientName,FIND(",",ClientName)-2)
That is dependant on names being separated by comma then space, if no comma
then in the formulas instead of comma between inverted commas, use a space
and perhaps alter the numbers to suit

Regards
Philip


"V. Roe" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I need to fill two textboxes on a userform with information from one cell.
> In Range ("ClientName") is text "Last, FirstName". I need to fill
> Textbox1
> with "LastName" and Textbox2 with the "FirstName". I have no problem
> filling the textbox with the entire text from the cell, but I have no idea
> how to split the information at the comma. The only information I could
> find suggested using the Left function, but since the number of characters
> can vary that didn't work too well. Any help would be greatly
> appreciated.
> Thanks
> Valerie
>
>

Left(ClientName, WorksheetFunction.Find(",", ClientName) - 1) and
Right(ClientName, Len(ClientName) - WorksheetFunction.Find(",", ClientName)
- 1)


"V. Roe" wrote:

> Hi,
> I need to fill two textboxes on a userform with information from one cell.
> In Range ("ClientName") is text "Last, FirstName". I need to fill Textbox1
> with "LastName" and Textbox2 with the "FirstName". I have no problem
> filling the textbox with the entire text from the cell, but I have no idea
> how to split the information at the comma. The only information I could
> find suggested using the Left function, but since the number of characters
> can vary that didn't work too well. Any help would be greatly appreciated.
> Thanks
> Valerie
>
>
>

Thanks to both of you this worked great.

"bigwheel" <[email protected]> wrote in message
news:[email protected]...
> Left(ClientName, WorksheetFunction.Find(",", ClientName) - 1) and
> Right(ClientName, Len(ClientName) - WorksheetFunction.Find(",",
ClientName)
> - 1)
>
>
> "V. Roe" wrote:
>
> > Hi,
> > I need to fill two textboxes on a userform with information from one
cell.
> > In Range ("ClientName") is text "Last, FirstName". I need to fill
Textbox1
> > with "LastName" and Textbox2 with the "FirstName". I have no problem
> > filling the textbox with the entire text from the cell, but I have no
idea
> > how to split the information at the comma. The only information I could
> > find suggested using the Left function, but since the number of
characters
> > can vary that didn't work too well. Any help would be greatly
appreciated.
> > Thanks
> > Valerie
> >
> >
> >