Removing characters from a cell

Hello,

I am trying to trim of characters within a cell on both the left and right sides. My cell value is 21.45 [23.23] and I can remove the one side or the other using (for example) =RIGHT(E10,LEN(E10)-7) to remove the left side characters. My goal is to have a cell that says just 23.23. How can I do both? can I use to formula's in one cell? If so, how? Any other suggestions?

Thanks,
Clint

If the value of A1 is [23.23], then you can use:

Please Login or Register  to view this content.

If the value of A1 is 21.45 [23.23], then try:

Please Login or Register  to view this content.

This may return a text string. If you need a value, then use the VALUE function:

Please Login or Register  to view this content.

Thanks Jason, that worked perfectly! thanks a million!

No problem. Glad I could help you out.

Originally Posted by xtrout

Hello,

I am trying to trim of characters within a cell on both the left and right sides. My cell value is 21.45 [23.23] and I can remove the one side or the other using (for example) =RIGHT(E10,LEN(E10)-7) to remove the left side characters. My goal is to have a cell that says just 23.23. How can I do both? can I use to formula's in one cell? If so, how? Any other suggestions?

Thanks,
Clint

If you always have the same number of characters (5) in the same position perhaps

=MID(E10,8,5)+0