Get text

[Romano_odK]

Good afternoon,

Is it possible to get text from a certain position? When I write a date, like 11-10-2021, I need to get these into another cell like this 2021-10-11, so the other way around and I can not use the date cell format. So I need to read the position like 11 is position 1 and 2 etc. Can this be done?

Thank you for your time,

Romano

 

[Sufiyan97]

Try for Data in cell A1

=CONCATENATE(YEAR(A1),"-",DAY(A1),"-",MONTH(A1))

 

[Romano_odK]

Try for Data in cell A1

=CONCATENATE(YEAR(A1),"-",DAY(A1),"-",MONTH(A1))

This does the trick, thank you for your reply.

Kind regards,

Romano

 

[Sufiyan97]

You're welcome
Glad it helped.

 

[Peter_SSs]

I can not use the date cell format.

Why not?**
Below, you can see from the formula that the cells contain the same value. I have just formatted the columns with custom date formatting.

21 10 19.xlsm
	A	B
1	11-10-2021	2021-10-11
Date format

Cell Formulas
Range	Formula
B1	B1	=A1

** Perhaps it is that you are looking for a text value in the second cell rather than a numerical date value?
If so, you could try this simpler formula instead

=TEXT(A1,"yyyy-d-m")

 

[Romano_odK]

Why not?**
Below, you can see from the formula that the cells contain the same value. I have just formatted the columns with custom date formatting.

21 10 19.xlsm
	A	B
1	11-10-2021	2021-10-11
Date format

Cell Formulas
Range	Formula
B1	B1	=A1

** Perhaps it is that you are looking for a text value in the second cell rather than a numerical date value?
If so, you could try this simpler formula instead

=TEXT(A1,"yyyy-d-m")

Good evening,

The reason why I do not want to use the date format is because I will be exchanging this sheet with Dutch and English users and I know from the past that date formats do not always go right. The solution above here works for me. Thank you for your input.

 

[Peter_SSs]

The reason why I do not want to use the date format is because I will be exchanging this sheet with Dutch and English users and I know from the past that date formats do not always go right. The solution above here works for me.

Thanks for the additional information.
Just noting again though that you can get the same result with a single function, as shown at the bottom of post #5, instead of calling on four separate functions.