LEN function

[Al]

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

 

[Jim Thomlinson]

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...

 

[Mike H]

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]

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]

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)

 

[Al]

Brilliant Jim, substitute worked perfectly!!! Thanks Al