Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Excel Function that will return # of char in preceding cell
I used it before and cant remeber the function command that will allow me to
copy just the 1st 5 numbers in a cell to another cell. Thes cells are like C & D. Thanks for your help. Command just slipping my mind. |
#2
|
|||
|
|||
Are you perhaps talking about:
In D1, enter, =LEFT(C1,5) OR =--LEFT(C1,5) to retain numerical format. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "klafert" wrote in message ... I used it before and cant remeber the function command that will allow me to copy just the 1st 5 numbers in a cell to another cell. Thes cells are like C & D. Thanks for your help. Command just slipping my mind. |
#3
|
|||
|
|||
In D1, LEFT(C1,5) will return the first five characters in C1.
"klafert" wrote: I used it before and cant remeber the function command that will allow me to copy just the 1st 5 numbers in a cell to another cell. Thes cells are like C & D. Thanks for your help. Command just slipping my mind. |
#4
|
|||
|
|||
The 'first' 5 numbers can be interpreted in two ways: 123456 =LEFT(C1,5) --- "12345" (this is a text) =--LEFT(C1,5) ---12345 (this is a number) 654321 =RIGHT(C1,5) --- "54321" (this is a text) =--RIGHT(C1,5) ---54321 (this is a number) HTH Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380387 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |