You do know where you have “F:F” you could do “F:F/1” right? Which would fix this and accomplish it with minimal effort and allow future discrepancies entered to work 🤷🏻♂️
2025-02-19 07:20:05
13
ChrisK.Wonders :
When you convert a pdf and the date format is (for example) 202502, how can we convert that to a date format? When I use the format cells feature it still doesn’t recognize as date and id like 2 sort
2025-02-20 06:58:26
0
Blue five leader :
Sweet
2025-03-11 22:27:52
0
⚛️Joako⚛️🏳️⚧️🏳️🌈=❤️ :
or you multiply the text array by 1* in the same lookup formula. much easier.
2025-02-23 15:32:24
0
juijhhhru76 :
Text to Colums text column and done
2025-03-12 06:57:36
0
FidoudaMax :
Put the text fonction directly in the xlookup formula
2025-04-04 03:33:56
0
restless_seeker :
or just change the data type in F to be values and not text
2025-04-08 23:08:50
0
D.S.Meliodas :
If you wanted to avoid having to change data types you could also do xlookup(left(c2) and use a formula to make it a text type.
2025-02-24 08:25:54
1
The Excel Guy :
Kyle, my wife is getting stronger and continues to beat me. Any advice?
2025-02-19 18:00:54
0
Pragnesh :
could you use -- on the lookup row
2025-02-21 06:49:44
0
Monogatari_X :
How do you get that pre hover feature of the cells ? Pretty neat and easy for the eyes to follow
2025-02-20 00:27:03
1
illuminatedshades :
❤️
2025-02-20 23:16:31
0
Screwstonman23 :
Data > Text to columns.. fixed
2025-02-23 22:49:24
0
To see more videos from user @excel_with_kyle, please go to the Tikwm
homepage.