Convert a sentence in a cell with the American date
Closed
grbrck
TrowaD
- Posts
- 1
- Registration date
- Friday April 21, 2017
- Status
- Member
- Last seen
- April 21, 2017
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- American xvideoservicethief
- Find a text in a sentence inside a cell ✓ - Forum - Office Software
- How to convert mm/dd/yyyy to dd/mm/yyyy in excel cells - Guide
- Convert cell value to integer vba - Forum - Office Software
- Mp3con converter - Download
- Iwisoft free video converter - Download
1 reply
TrowaD
Apr 24, 2017 at 12:08 PM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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