Thank you! You are the only person I found to address the actual problem I had! :)
@royaarabi7879
8 ай бұрын
Saved my day! Thank you so much
@JCEurovisionFan1996
Жыл бұрын
Can you do a video on how to do the word count, unique word count, and the most popular words on Microsoft Excel? I mean, that video on Google Sheets really helped those who are at the intermediate to advanced level when it comes to data analysis.
@ExcelGoogleSheets
Жыл бұрын
Do you have TEXTSPLIT & TOCOL functions in your Excel version?
@JCEurovisionFan1996
Жыл бұрын
@@ExcelGoogleSheets No, I'm afraid.
@ExcelGoogleSheets
Жыл бұрын
Then your best bet is Power Query.
@JCEurovisionFan1996
Жыл бұрын
@@ExcelGoogleSheets I would love to have a video on that.
@ExcelGoogleSheets
Жыл бұрын
kzitem.info/news/bejne/o4am3maQjZ15g2k
@profocelsomarin4123
Жыл бұрын
Hi! It would be possible for you to address in one of your videos how we can have fractions without simplifying them. I mean, I need tet 2/4 without it turning 1/2. Thanks for your videos, they are great
@ExcelGoogleSheets
Жыл бұрын
You'd have to store it as text.
@icctmedia
Жыл бұрын
How to change 3D pie chart Labelled percentage to Value in Google Sheet
Жыл бұрын
hi, i use VALUE function to convert text to number most of the time. but i got a weird problem when i copy a table from a pdf then past to the google sheet. value function didn't work. it said " value parameter '0 ' cannot parse to number. i tried change the format from automatic to number then back to automatic, but it still didn't work . do you have any suggestion? thank you
@ExcelGoogleSheets
Жыл бұрын
=VALUE(TRIM(A1))
Жыл бұрын
@@ExcelGoogleSheets i have tried trim and =substitute(A1," ","") before both of them didn't work as well,. finally i have to copy and past value and functions like 10 times. it doesn't happened all the time but sometimes it just get so weird. thanks for your help : )
@ExcelGoogleSheets
Жыл бұрын
Well, then it's something that looks like a space but it's some sort of special character. Maybe try =VALUE(REGEXREPLACE(TRIM(A1),"[^0-9.,]",""))
Жыл бұрын
@@ExcelGoogleSheets it works!!! thank you so much :))))
@amari.yanara
Жыл бұрын
@@ExcelGoogleSheets Oh my goodness, thank you for this one! There's a conversion that wasn't working on my spreadsheet and this sorted it out. Thank you so much!!
@SkodaUFOInternational
Жыл бұрын
nah
@GGdude
10 ай бұрын
Here i was hoping i would see actual convert text(letters) to numbers and not convert a cell from text to numbers. Oh well back to googling.
@jessrscott
8 ай бұрын
Same.. Finally found a good solution for that: kzitem.info/news/bejne/0oJ7mJ-EbaJziIIsi=4nMg1Ihs2J-fbfmK
Пікірлер: 21