Home > Forum Home > Excel Portfolio Optimization Template > Working with text Share

Working with text

Excel Help for Working With Text in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Working With Text

Rate this:
(3/5 from 1 vote)
Confused Hello,
I have a list of book titles and I need to highlight the books that start with the letter "T". How can I do it?
 Posted by on
 
Replies - Displaying 1 to 6 of 6Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
nice thanks
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
hello alll nice post i like it !
 henewo33
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
nice post
 ankur
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Sure, I can help you with working with text in Excel for portfolio optimization. Please let me know what specific tasks you need assistance with, and I'll do my best to guide you.
Here are some general tips and techniques for working with text in Excel:
  1. Concatenation: You can combine text from multiple cells into one cell using the CONCATENATE function. For example, if you have first names in cell A2 and last names in cell B2, you can combine them into one cell using the formula =CONCATENATE(A2," ",B2) to create a full name.
  2. Text functions: Excel has a number of functions that can help you work with text. For example, you can use the LEFT function to extract the first few characters of a cell, or the RIGHT function to extract the last few characters. The LEN function can tell you the length of a cell's contents, and the FIND function can help you locate specific characters within a cell.
  3. Text-to-Columns: If you have a column of data that needs to be split into multiple columns, you can use the Text-to-Columns feature. This allows you to separate the data based on a delimiter, such as a comma or a space.
  4. Find and Replace: If you need to change certain text in your spreadsheet, you can use the Find and Replace feature. This allows you to search for a specific piece of text and replace it with something else.
  5. Formatting: You can use formatting to change the appearance of text in your spreadsheet. For example, you can change the font, size, color, and alignment of your text to make it more readable.
  6. I hope these tips are helpful! Let me know if you have any specific questions
 Robert F Harmon
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Thank you, I haven't even thought the solving could be so easy!
 Posted by on
Happy
Rate this:
(3/5 from 1 vote)
Use conditonal formatting with rule:
  • Format only cells that contain
  • Specific Text > beginning with > "T"
  • Format fill color to highlight.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Working with text in the