RIGHT Arguement?
Hi
I can't see the earlier thread, but if Chuck's answer of
=MID(A1,5,1)
is what you want to include within parentheses, then
="("&MID(A1,5,1)&")"
should do what you want.
--
Regards
Roger Govier
"jrivel" wrote in message
...
Is there a key for how to place letters/numbers between parenthesis to
return
an answer?
"CLR" wrote:
You're welcome, just keep in mind that the basic formula
=MID(A1,5,1)
will return a TEXT version of the 5th character, whereas this version
=MID(A1,5,1)*1 will convert it back to Numerical
Vaya con Dios,
Chuck, CABGx3
"Saxman" wrote:
David Biddulph wrote:
=MID(A1,5,1)
It works fine!
Thanks everybody.
|