Return a Variable value length
 

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


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

Return a Variable value length
 

Here's one possibility:

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

Scott

Sean wrote:
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


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

Return a Variable value length
 

Try this:

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

Biff

"Sean" wrote in message
oups.com...
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


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

Return a Variable value length
 

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

Sean wrote:
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


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

Return a Variable value length
 

Here you go

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

-John

"Sean" wrote:

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


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

Return a Variable value length
 

Thanks everyone, choice of options here

T. Valko wrote:

Try this:

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

Biff

"Sean" wrote in message
oups.com...
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


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