ExcelBanter - Text to YYYY format

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Text to YYYY format (https://www.excelbanter.com/new-users-excel/204600-text-yyyy-format.html)

sojuman

Text to YYYY format

I have text in column "B" that is formatted YYANNNNN (01B12345). I would
like to change to YYYY (2001) format in column "A".

Thanks

Rick Rothstein

Text to YYYY format

Give this a try...

As text: =TEXT("1/1/" & LEFT(B1,2), "YYYY")

As number: =--TEXT("1/1/" & LEFT(B1,2), "YYYY")

--
Rick (MVP - Excel)

"sojuman" wrote in message
...
I have text in column "B" that is formatted YYANNNNN (01B12345). I would
like to change to YYYY (2001) format in column "A".

Thanks

sojuman

Text to YYYY format

Works like a charm. Thanks

"Rick Rothstein" wrote:

Give this a try...

As text: =TEXT("1/1/" & LEFT(B1,2), "YYYY")

As number: =--TEXT("1/1/" & LEFT(B1,2), "YYYY")

--
Rick (MVP - Excel)

"sojuman" wrote in message
...
I have text in column "B" that is formatted YYANNNNN (01B12345). I would
like to change to YYYY (2001) format in column "A".

Thanks

All times are GMT +1. The time now is 12:43 AM.