Share via

I would like to now if it is possible to copy cell values in Excel from one cell to another cell based on the properties of a text string. For example only Red text or Bold type text.

Rini Schuiling 21 Reputation points
2021-03-08T10:05:22.533+00:00

I want to automate the process in Excel of copying text strings from one cell to another cell based on the text properties. A cell can contain long text strings with parts of the text as bold or with a red color. Is it possible to select text based on its properties?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,660 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erin Ding-MSFT 4,456 Reputation points
    2021-03-09T10:08:04.413+00:00

    @Rini Schuiling

    Please check if Lz-3068's reply is helpful to you.
    If you have further question about VBA code, you could modify the tag to be "office-vba-dev" to get related help, as tag "office-excel-itpro" focuses on general issues about Excel clients and VBA code is out of its scope.
    Thanks for your understanding.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments