separate a string in a cell

[jflaurin]

i have a cell with " Last name, First name " a comma separates the first from last name. How can I extract only the first name ?

I know it's simple to do....but I only had 1 coffee today and can't figure it out

 

[SkipVought]

Hi,

No VBA required, unless you want to macro recoed.

Data > Text to columns.

Choose DELIMITER and COMMA as the delimiter. Step 3, select the Column data format Do not import column (skip)

Alternatively, you can use the LEFT, FIND & LEN functions in a formula in an adjacent column.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Bong]

Let c be the cell reference, i.e., set c = sheet1.range("g42") or some such.
Then c.value is your name1,name2 thingy.

n=split(c.value,",")
lstName=n(0)
fstName=n(1)

_________________
Bob Rashkin