@excel_with_kyle: How to fix data type mismatches in Excel! #exceltricks #exceltips #excel #greenscreenvideo #exceltutorial #microsoftambassador

Excel With Kyle
Excel With Kyle
Open In TikTok:
Region: US
Tuesday 18 February 2025 21:02:41 GMT
58474
1302
22
86

Music

Download

Comments

scottelliott10
Scott Elliott :
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
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
bluefiveleader
Blue five leader :
Sweet
2025-03-11 22:27:52
0
joakobob
⚛️Joako⚛️🏳️‍⚧️🏳️‍🌈=❤️ :
or you multiply the text array by 1* in the same lookup formula. much easier.
2025-02-23 15:32:24
0
juijhhhru76
juijhhhru76 :
Text to Colums text column and done
2025-03-12 06:57:36
0
fidoudamax
FidoudaMax :
Put the text fonction directly in the xlookup formula
2025-04-04 03:33:56
0
restless_seeker
restless_seeker :
or just change the data type in F to be values and not text
2025-04-08 23:08:50
0
gfsv665
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
onlyexcelguy
The Excel Guy :
Kyle, my wife is getting stronger and continues to beat me. Any advice?
2025-02-19 18:00:54
0
pragslyfe
Pragnesh :
could you use -- on the lookup row
2025-02-21 06:49:44
0
monogatari_x
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
illuminatedshades :
❤️
2025-02-20 23:16:31
0
leothegreat89
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.

Other Videos


About