ExcelBanter - REFORMAT A TEXT CELL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - REFORMAT A TEXT CELL (https://www.excelbanter.com/excel-discussion-misc-queries/29837-reformat-text-cell.html)

Jerry Arnone, PMP

REFORMAT A TEXT CELL

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

--
Jerry Arnone
PMP, IT PROJECT+, CCNA, MCSE, CCA, CNA,
A+, SECURITY+, MS Project White Belt

Peo Sjoblom

Try custom format

"^("@")"

Regards,

Peo Sjoblom

"Jerry Arnone, PMP" wrote:

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

--
Jerry Arnone
PMP, IT PROJECT+, CCNA, MCSE, CCA, CNA,
A+, SECURITY+, MS Project White Belt

Jerry Arnone, PMP

THANKS FOR THE HELP!!!!
--
Jerry Arnone
PMP, IT PROJECT+, CCNA, MCSE, CCA, CNA,
A+, SECURITY+, MS Project White Belt

"Peo Sjoblom" wrote:

Try custom format

"^("@")"

Regards,

Peo Sjoblom

"Jerry Arnone, PMP" wrote:

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

--
Jerry Arnone
PMP, IT PROJECT+, CCNA, MCSE, CCA, CNA,
A+, SECURITY+, MS Project White Belt

All times are GMT +1. The time now is 10:16 PM.