View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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.