Microsoft Excel Functions & Formulas

Use the FIND function to combine text and date

The following worksheet contains daily tasks in column A and their

corresponding dates in column B. The task here is to combine the

data and change the format of the dates. Take a closer look at the

following screenshot:

The text string XXX has to be replaced by the dates in column B.

To do so, the starting position of the text string has to be deter-

mined by using the FIND function. The REPLACE function will

replace the XXX text string with the date.

FIND(find_text, within_text, start_num)

find_text: Text to find. Wildcard characters are not allowed.

within_text: Text containing find_text.

start_num: Specifies ...