Thread: How to separate First name and Last Name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Leo Heuser[_2_] Leo Heuser[_2_] is offline
external usenet poster
  
Posts: 111
Default How to separate First name and Last Name
Michelle

One way:

FirstName = Split([D3]," ")(0)
LastName = Split([D3]," ")(1)

To use this solution, you must have
Excel 2000 or later.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"michelle_ho " skrev i en
meddelelse ...
Suppose in cell D3, the value is "Christine White".

I have two variables, firstName and lastName as String.

How can I separate "Christine White", so that firstName = "Christine"
and lastName = "White"??

Thx a lot!


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote