FIND() vs SEARCH() Function in Excel

FIND() vs SEARCH() Function in Excel

TeachExcel

4 года назад

147,832 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@darrylmorgan
@darrylmorgan - 28.07.2020 15:34

Great Tutorial Really Well Explained..Thank You Sir :)

Ответить
@sureshlovevanshi6944
@sureshlovevanshi6944 - 28.07.2020 19:47

Hello there...is it possible to run a macro just after power query refresh automaticaly ...Data Refresh then Macro Run ...

Ответить
@nadermounir8228
@nadermounir8228 - 29.07.2020 01:12

Well explained thank you for your hard work

Ответить
@Richkotite1
@Richkotite1 - 29.07.2020 02:06

Really well explained. Thank you.

Ответить
@wayneedmondson1065
@wayneedmondson1065 - 29.07.2020 07:10

Great advice! Easy to make a mistake if not well understood between the two functions. Thanks for the lesson. Thumbs up!!

Ответить
@IvanCortinas_ES
@IvanCortinas_ES - 19.08.2020 14:10

A great explanation. Thank you for telling us the examples with wildcards!

Ответить
@jacobchama6562
@jacobchama6562 - 28.05.2021 00:22

I HAVE A HUGE LIST OF NUMBERS AND I NEED TO FIND 191 FROM THE LONG LIST PLEASE HELP

Ответить
@lisaramaha2304
@lisaramaha2304 - 30.05.2021 00:34

What to do if there is multiple same data in same column, how to get both data Position number

Ответить
@nmmn2700
@nmmn2700 - 06.08.2021 08:07

Hi


I have one question



Coloum A
Ans
Some text
Question
Some text
Question
Some text
Question
Some text
Ans
Some text



50000 like this

I need
Coloum A. Coloum B
Ans. Some text
Question. Some text


I need like this if you know could you please let me know

Ответить
@keithfalcao1844
@keithfalcao1844 - 28.01.2022 01:20

I have watched this twice , still have no idea what your talking about

Ответить
@MertBayramoglu
@MertBayramoglu - 31.01.2022 12:13

You talk too much nonsense. The 3 minute video was 11 minutes. An expert is someone who describes an event simply and in a short time.

Ответить
@moriravirajsinh1300
@moriravirajsinh1300 - 16.02.2022 16:21

Well explained...

Ответить
@jimcrain412
@jimcrain412 - 29.04.2022 19:21

BTW: if you need to search for a ~, you must use ~~ in your find_text string. It happened to me…

Ответить
@verdis1952
@verdis1952 - 20.07.2022 12:27

Very helpful, thanks

Ответить
@ekramhossain7014
@ekramhossain7014 - 18.10.2022 19:31

Thank u so much sir

Ответить
@DormantRV
@DormantRV - 18.11.2022 03:29

What I want to find the position of space before the word "Value" ....

Ответить
@nareshkumarmaurya5400
@nareshkumarmaurya5400 - 23.12.2022 10:07

Thanks sir

Ответить
@DaddyBear3000
@DaddyBear3000 - 29.12.2022 14:22

This is VERY useful. I've just found additional results in a large database that had previously been missed by swapping to the search function.

Ответить
@nairobi203
@nairobi203 - 03.03.2023 23:06

I need to search starting from right to left... is this even possible?

Ответить