| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LEN function
Can somebody tell me how to use the Left and Right LEN command in the same
cell. I am trying to data from both ends... thanks Al |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LEN function
Need more info. Can you post an example of what you want to do including what
the original cell has in it and what you want the formula to return... -- HTH... Jim Thomlinson "Al" wrote: Can somebody tell me how to use the Left and Right LEN command in the same cell. I am trying to data from both ends... thanks Al |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LEN function
Al,
With the string Microsoft in A1 =LEFT(A1,3) returns 'Mic' RIGHT(A1,6) returns 'rosoft and in the same cell =LEFT(A1,3)&RIGHT(A1,6) Concatenates then together and returns 'Microsoft' Mike "Al" wrote: Can somebody tell me how to use the Left and Right LEN command in the same cell. I am trying to data from both ends... thanks Al |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LEN function
Jim, thanks for your help.
Cell A2 has this value *N223* I would like the return of N223 to go to cell A4 without the astericks. I don't know how to nest both Left and Right formulas. Here is my formula in A4, =LEFT(A2,LEN(A2)-1) RIGHT(A2,LEN(A2)-1), what do I need in between the two commands? "Jim Thomlinson" wrote: Need more info. Can you post an example of what you want to do including what the original cell has in it and what you want the formula to return... -- HTH... Jim Thomlinson "Al" wrote: Can somebody tell me how to use the Left and Right LEN command in the same cell. I am trying to data from both ends... thanks Al |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LEN function
The easiest way would be to just use substitute something like this...
=SUBSTITUTE(A1, "*", "") You could also use Mid and Len something like this =MID(A1, 2, LEN(A1)-2) -- HTH... Jim Thomlinson "Al" wrote: Jim, thanks for your help. Cell A2 has this value *N223* I would like the return of N223 to go to cell A4 without the astericks. I don't know how to nest both Left and Right formulas. Here is my formula in A4, =LEFT(A2,LEN(A2)-1) RIGHT(A2,LEN(A2)-1), what do I need in between the two commands? "Jim Thomlinson" wrote: Need more info. Can you post an example of what you want to do including what the original cell has in it and what you want the formula to return... -- HTH... Jim Thomlinson "Al" wrote: Can somebody tell me how to use the Left and Right LEN command in the same cell. I am trying to data from both ends... thanks Al |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LEN function
Brilliant Jim, substitute worked perfectly!!! Thanks Al
"Jim Thomlinson" wrote: The easiest way would be to just use substitute something like this... =SUBSTITUTE(A1, "*", "") You could also use Mid and Len something like this =MID(A1, 2, LEN(A1)-2) -- HTH... Jim Thomlinson "Al" wrote: Jim, thanks for your help. Cell A2 has this value *N223* I would like the return of N223 to go to cell A4 without the astericks. I don't know how to nest both Left and Right formulas. Here is my formula in A4, =LEFT(A2,LEN(A2)-1) RIGHT(A2,LEN(A2)-1), what do I need in between the two commands? "Jim Thomlinson" wrote: Need more info. Can you post an example of what you want to do including what the original cell has in it and what you want the formula to return... -- HTH... Jim Thomlinson "Al" wrote: Can somebody tell me how to use the Left and Right LEN command in the same cell. I am trying to data from both ends... thanks Al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
