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
|
|||
|
|||
=LEFT(C1,5)
-- HTH RP (remove nothere from the email address if mailing direct) "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
|
|||
|
|||
You've gotten several answers both here and in the Misc group with everyone
thinking by "first" five characters you meant the "leftmost" characters..........if indeed you meant that, so much is fine, but if you actually meant the "rightmost" five characters as being the "first", then use this formula =RIGHT(C1,5) Vaya con Dios, Chuck, CABGx3 "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. |
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 |