Microsoft Excel and Google Sheets are powerful tools for data analysis and computation. They offer functions that enable users to efficiently work with data. In this article, we will explore the FIND and FINDB functions — known as BUL and BULB in Turkish — used in Excel and Google Sheets. These functions are used to find the position of a text string within another text string.

Syntax of BUL and BULB Functions

The basic usage of the BUL and BULB functions in Excel and Google Sheets is as follows:

=BUL(aranan_metin, içinde_aranan_metin, [başlangıç_noktası]) =BULB(aranan_metin, içinde_aranan_metin, [başlangıç_noktası]) 

• aranan_metin: The text fragment you are searching for.
• içinde_aranan_metin: The broader text area within which the search text fragment is located.
• başlangıç_noktası: An optional argument. The search starts from this character position. If not specified, the default is 1, meaning it starts at the beginning of the text.

Usage Examples

Examples of practical uses for the functions described above:

1. Simple Text Search: Finding the starting position of a specific word within a sentence.
2. Advanced Search: Finding the first occurrence of a word after a specific starting point.

Problems and Solutions

Let’s examine two different scenarios to see how these functions can be used step-by-step.

Problem 1: Simple Text Search

Scenario: Find the starting position of the word “harika” in the sentence “Merhaba dünya, bugün harika bir gün!”.

=BUL("harika", "Merhaba dünya, bugün harika bir gün!") 

This formula returns the starting position of “harika” within the sentence “Merhaba dünya, bugün harika bir gün!”. The result is 25 because “harika” begins at the 25th character.

Problem 2: Advanced Search

Scenario: In the sentence above, find the first occurrence of the word “gün” starting from the 10th character onward.

=BUL("gün", "Merhaba dünya, bugün harika bir gün!", 10) 

This formula searches for “gün” starting from the 10th character and returns the position of the first occurrence. Because the word starts at the 28th position, the result is 28.

These functions are extremely useful in text processing and data analysis, particularly when searching for specific information within large texts, thus saving time.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/bul-bulb-işlevleri-c7912941-af2a-4bdf-a553-d0d89b0a0628