:Trick! Part of the text in 1000 cells is bolded and changed to red font!-Picture material template recommendation免费ppt模版下载-道格办公

There is a column of content, about 1000 cells

Now you need to edit the text from "Team" to the end in each cell

All changed to red font and bold

The easiest way is to select this part of the text in the formula bar of each cell

Then change the font color to red and bold

But doing this for 1000 cells

Still too slow, 1 cell modification takes 30 seconds

500 minutes for 1000 cells

In this way, it takes only one day to modify the text attribute settings.

too tired

Here is a recommended way to use HTML to operate

Of course, you can also study using the word search and replace method

But there are not too many steps

1. First enter the following formula in cell B1

This formula uses the HTML syntax

With the help of LEFT and FIND and MID functions

extract desired text from cell

Add HTML syntax before and after it

='<table>'&

LEFT(A1,FIND('Team',A1)-1)&

''&

MID(A1,FIND('Team',A1),100)&

''

2. Then select the area in column B

In this example, the cell range B1:B10 is selected

then copy

Open the clipboard (click the Paste launcher in the Home tab)

3. Then click an empty cell such as the C1 edit column with the mouse,

Then click on the saved content in the left clipboard

At this time, there is all the content in cell C1

4. Select column C, ctrl + H to find and replace, find ' to replace all

5. Go to the C1 editing column and press ctrl+a to select all content, and ctrl+x to cut

6. Then select a cell such as D1, ctrl+v to paste

get the red font

7. Adjust the font size of column D as needed, and set automatic line wrapping

8. Select column D, ctrl+g positioning condition, empty value, right click, delete, move the lower cell up

Of course, you can also study the Word find and replace method

You can also study the VBA method

But it's not easy, especially the VBA method

After all, our needs

Excel built-in functions are not provided

that's the trouble

Recommend this good online course

Selection of quality, excellent work"520 Sections-Excel+PPT+Word Little White Becomes a Great Master"

This big promotion is very strong, students who haven't bought it yet,

Friends in need, please add me on WeChatchange12365

Give you a super value surprise, only this time, never again

We will give you a lot of rewards and benefits beyond expectations, unprecedented!

Extra-value Excel online class, free 211 sets of high-quality PPT templates! Send coupons to deduct! Hurry up!

The most important thing is that after completing this course, a promotion and salary increase will definitely come!

520 online video courses that have completed 99.99% of Office online courses

Welfare surprises, overjoyed One time purchase, permanent validity

Guiding and answering questions, long-term companionship In-depth system, easy to understand

A master, the promise will be achieved Unprecedented in history, a masterpiece

Thousands of mountains and rivers, only this one Promotion and marketing, no tricks

Countless online courses, I will not regret learning Super value video, a set of gods

Skills book, must be in the bag Clear the source, take a shortcut to the peak

Long press the picture below to identify the QR code of the picture and go directly to the course purchase address

You can consult Mr. Li Zejian before buying, the WeChat account is on it

More than 7,500 people have joined the study But you have been hesitant to study

Compared to others The future is decided at a certain moment

Your thinking limits your future

Purchase link, long press the picture to identify the QR code

Click "Read the original text" Join learning, change yourself, just one point

One lesson changes Office workplace efficiency, multiplying by a hundred times and a thousand times

Promotion and salary increase without overtime, changing career development trajectory

Promise to learn the course well and wechat tutoring can solve 97% of the problems in the workplace

From then on, change yourself to a new peak and open up new possibilities, just stay here and make a decision

Choose what you believe in, make your choice

Everyone's change comes from one accidental but firm choice after another

Meeting my course is such a coincidence

I would like to feel the fate here, and start a wonderful and different future from now on

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/Trick%20Part%20of%20the%20text%20in%201000%20cells%20is%20bolded%20and%20changed%20to%20red%20font.html