REFORMAT A TEXT CELL

[Guest]

HI,

I NEED TO REFORMAT A CELL TO INCLUDE A "^" AND A "(" AT THE BEGINNING OF THE
CELL AND A ")" AT THE END.
EXAMPLE OLD: JONES
EXAMPLE NEW ^(JONES)

ANY HELP IS GREATLY APPRECIATED

 

[Guest]

Try custom format

"^("@")"

Regards,

Peo Sjoblom

 

[Guest]

THANKS FOR THE HELP!!!!
--
Jerry Arnone
PMP, IT PROJECT+, CCNA, MCSE, CCA, CNA,
A+, SECURITY+, MS Project White Belt
(e-mail address removed)