How will your code split these two names (both are friends of mine)?

Joseph Della Rossa (Della Rossa is his last name)

Mary Anne Whitfield (Mary Anne is her first name)

--
Rick (MVP - Excel)


"Tree*Rat" wrote in message
6.253...
gls858 wrote in
:

Tree*Rat wrote:
in my input box the question is long and need to split it down. How
do i get this

"please enter name of guests - First name, last name sperated buy a
comma"

to this

"Please enter guests name"
"First name, last name"
""
"Seperated by a comma"




current code
------------
GuestName = InputBox("please enter name of guests - First name, last
name sperated buy a comma", "Enter name")


big thx

Usually it's best to store the first name and last name as separate
fields.

gls858

they will be stored as seperate fields as I will split the input. hence
the comma. But thanks anyway!