Get instant live Excel expert help with Text Functions

In VBA I need to create a Macro that will: - Accept via an Input box a range of values. This range can be typed (A6:A10) or drag selected via the mouse. - If any of the values are empty, inform the user via a msgbox and do not execute further. -Enter the range selected in cell C2. -The values of the selected range should be strung together into one long text string. Each value should have a single apostrophe in front, a single apostrophe at the end, and a comma and space at the end. The very last value will not have a comma and space at the end. Example for a selection of A6:A9: 'A0001', 'A0002', 'A0003', 'A0004' -Enter completed selection in cell C3. Thank you!!

Hi, I'm looking to create a from by typing in the reg and it pulling through the data from the data tab. I've tried this as a VLookup but it only pulls through the first line and there may be more than one line under each reg for repair history. I tried doing this as a pivot table, but I don't like the layout of it and wanted to be able to type in a reg and it search for the data rather than filtering. I've tried a combination of both by creating a macro to copy the data from cell A1, refresh the data in the pivot table, filtering by pasting the results from A1 then copying the relevant data I require onto the form tab. It works, but when I change the reg it remembers the actual reg text from the macro rather than the act of copying and pasting the data in A1 from the form. Can you help me please? Is there anyway that I can do this?

Needing help with my current formula not working in column E, due to text and numbers

I have a huge database of columns and put TRUE or FALSE in them. Unfortunately, I needed to put the column header text instead of TRUE or FALSE. Is there a formula to be able to replace the TRUE values to the heading text without having to find and replace each column at a time?

Please help us with the above. I have errors regarding the code. Firstly I want to send myself an automated email with the nearing due dates with name and license number specified. Also require less complexity. And want a proper solution. I need a particular solution. I will be attaching a dropbox file. Please help me regarding the multiple selection of field in the same text.

I need a formula that can detect text change in sheet 1 and then print a list of changes in "text" in sheet 2

I need help auto calculating and moving text from one column to another when a date is entered

continuous count number of cells with text only...I've submitted a file

Need to get text from cell C from a table if cell A contains " " and if cell B contains " "

I wish to protect a cell to prevent formula from being deleted, however, the cell text is dependent on other cells and when protected, it will not automatically be changed.