LEN function

A

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
 
J

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

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
 
A

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?
 
J

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)
 
Top