IS THERE A FORMULA IN EXCEL THAT CAN DELETE A WORD IN A CELL?

There is no direct formula, but the individual functions are nested within each other to achieve this.

It's easier to solve if you define it with macros.

Examples:"bcdefghaccee"To delete the"a"character, let it become"bcdefghccee"

Enter this character in A1 and the character you want to delete in B1"a"This can be achieved by entering the following formula in C1.

concatenate(left(a1,find(b1,a1,1)-1),right(a1,len(a1)-find(b1,a1,1)))

Enter the formula in cell d2

c2*50)/

Then hover over the lower right corner of the cell and hold down the Ctrl key to pull it down!

You type the word you want to delete in the substitution, and then replace it without entering it.

No, you can define a macro yourself to do this.

If the previous cell contains a certain character, perform the following steps to return the specified character in the current cell:

There are several names in column A in column A, as shown in the figure below, at this time, you should find out whether the cell in column A contains the word "some" in column B, if there is, return "have", if not, return "none", then click cell B1, and then click on the formula bar.

2. Enter the formula =if(iserror(find() in the formula bar of cell b1"Certain", a1)), none","Yes")

3. Then click the " " on the formula bar and finally drop down to fill in the formula.

Fourth, the final effect is as shown below, at this time, the cells in column B can be detected whether the cells in column A contain the word "so" (note that the "have" and "none" two-level source bridge characters in the formula can be replaced with the text or specific symbols you need, but pay attention to keep double quotation marks).

<> "You can delete formulas in Excel by following these steps: 1Select a range of cells that contain formulas, which can be a single cell, multiple cells, or the whole worksheet.

2.Use the Cut action to copy the selected range to the clipboard, using the shortcut Ctrl+X or right-click the selected range and choose Cut. 3.

Select the target area you want to paste, it can be other cells in the same worksheet or different worksheets. 4.Use the Paste action to paste the contents of the clipboard into the selected target area, using the shortcut Ctrl+V or right-click the target area and choose Paste.

5.In the paste options that pop up, select the Value option to keep only the text and data without the formula. With the above steps, you can quickly delete the formulas you are using and keep only the text and data.

Note, however, that this will remove the formula and replace it with the calculated result, so make sure you have calculated the desired result before you do so.

<> enter or copy and paste the following formula in B2.

substitute(b1,a2,)

Pull-down padding. The results are slightly different from the required results.

Enter or copy-paste the following formula in B10.

right(b9,len(b9)-1)

Or. mid(b9,2,len(b9))

To write a formula, you need to use several commands: mid, find

For example, "123-12345678 consolidation 9 2004 abc transfers eli livelihood" is placed in cell A1, and the following consensus is written in cell B1:

mid(a1:a1,1,find("abc",a1,1)-2)

To explain: 1, find("abc",a1,1) In a1, starting from the 1st character, find the position of "abc".

2,mid In a1, the string is truncated from the first character, and the length to be intercepted is find()-2

Why subtract 2? Because you use find the position where abc appears for the first time, but the string you want to intercept does not include abc, so you have to subtract 1, and there is a space in front of abc, so subtract 1 to achieve the effect you want.

1.An Apple laptop with Mac OS X.

for mac 2011。

3.An excel with formulas.

Excel** cell formula removal method:

1.Open an Excel with Excel for Mac 2011 and select the cell with the formula.

2.Right-click and select Copy.

3.Right-click and select Paste Special.

4.Select the value in Paste and click the OK button.

5.See the results.

1. Select the result and right-click to copy.

2. Click "-Paste Special".

3. Select "Value" to confirm.

Copy the cell where the formula is located, then right-click the cell and paste the numeric value selectively.