Return a Variable value length

[Sean]

How would I return in say A2 the value that is in A1, but not all of
this value in A1, just the characters that are to the left of a decimal
point?

A1 = an email address and the value I want returned is the first name
on this address. The format of values in A1 is
[email protected]

Obviously the length of the firstname can vary.

To format it nicely I'd like to capitalise the first letter of the
value returned in A2

Thanks

 

[Scott]

Here's one possibility:

=UPPER(LEFT(A1,1))&MID(A1,2,FIND(".",A1)-2)

Scott

 

[T. Valko]

Try this:

=PROPER(LEFT(A1,FIND(".",A1)-1))

Biff

 

[jlepack]

A2 = =PROPER(LEFT(A1,SEARCH(".",A1,1)-1))

 

[John Bundy]

Here you go

=PROPER(LEFT(A1,FIND(".",A1)-1))

-John

 

[Sean]

Thanks everyone, choice of options here

Try this:

=PROPER(LEFT(A1,FIND(".",A1)-1))

Biff