Convert a sentence in a cell with the American date
Closed
grbrck
Posts
1
Registration date
Friday April 21, 2017
Status
Member
Last seen
April 21, 2017
-
Updated on Apr 21, 2017 at 04:22 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 24, 2017 at 12:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 24, 2017 at 12:08 PM
Related:
- American xvideoservicethief
- Xvideoservicethief - Download - Video downloads
- American truck simulator free - Download - Simulation
- American country code for whatsapp - Guide
- How to type @ on american keyboard - Guide
- Xvideoservicethief 2018 linux hdd usb port not working problem solution - Pen Drive, USB & SD Card Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 24, 2017 at 12:08 PM
Apr 24, 2017 at 12:08 PM
Hi grbrck,
Give this formula a try:
=LEFT(A1,LEN(A1)-5) & RIGHT(A1,2) & "/" & MID(A1,LEN(A1)-4,2)
Best regards,
Trowa
Give this formula a try:
=LEFT(A1,LEN(A1)-5) & RIGHT(A1,2) & "/" & MID(A1,LEN(A1)-4,2)
Best regards,
Trowa
