Get instant live Excel expert help with Text Functions

I need to create a formula which colours excel fields when the same text is found on two different tabs. For example on one sheet i have the text - BOWDOL, so when this appears on both sheets, it would highlight the field in a colour.

Hello, I am experiencing a problem at work with creating map on EXCEL. I have a range of rows and some rows with existing text inside. I am trying to put all the rows in exact range with gaps between some rows to make an equal length of rows. any ideas, please?

Hello, I am experiencing a problem at work with creating map on EXCEL. I have a range of rows and some rows with existing text inside. I am trying to put all the rows in exact range with gaps between some rows to make an equal length of rows. any ideas, please? Lets say I have 100 rows as a range, and I only have 20 cells in 20 rows with a text inside, I would like to make 1 cell every 5 rows to match total of 100 rows. Please

I download a text file from my credit card account of the previous months transactions. When I load the "external data" into my spread sheet I choose "fixed width." I can identify columns in the field that comes up but I can't move the display to the right to identify the remaining columns. My older version of Excel allowed me to scroll over. The new version doesn't.

my query is about the excel spread sheet the comments box! I understand that you can write text in it. However it would be more useful to me if I could insert a small thumb nail image or photo. Is this possible?

Complete either the Excel Application Exercise (3-21 on page 89) OR the Access Application Exercise (3-22 on page 89) at the end of Chapter 3 from Introduction to Information Systems. Data files referenced in the application exercise directions in the text are attached below.

I need a formula to match unique identifiers with duplicate text names in the cells to identify matching text so I can find the ones that are missing duplicate text.

I want to count how many rows have not had any action taken yet but are not yet Overdue. So my row G from cell G3 to G102 need to be blank and cell F3 to F102 need to be blank. I don't want it to count any rows that are blank (which naturally have the G and F columns blank. I want to count how many cells have F and G columns blank but still have text in column B which means that there is a task in that row. I've tried a few different formulas but they won't work.

Hi, I want to create a countdown to show when I go on R&R from work in Iraq. So far I have created a pie chart and separate data that shows how long I have been in country for and also how long I have left until I go on R&R using the required formulas and dates that says when I arrived in country and when I go on R&R. I would like to a function to this that shows when I have less than a month to go for R&R, with the text appearing below the pie chart stating "Less than a Month" when I have reached this time frame, and also I would like the same for when I reach a week or less. Was wondering if you could help on the matter please?

I am having an issue with converting columns to text for a CSV file. How to convert text file to csv?