Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
Performing a function on a column of variable length | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Pivot Table Zero Value | Excel Discussion (Misc queries) |