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

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

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

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

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

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