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