Get instant live expert help on How do I add character to string

Please help combine 28 string formulas into 1 x cell. I realize I need to break it up into different cells due to limit on character in string.

I am putting a time liner together. I would like to read the string of character and return in the start date and end date 2 separate cells. The string of characters is the number of resources and the header of my table are the dates

Hi, I have a character I need removed from all the rows in column C. It's this character { ' } . Funny thing is that you only see the character when you click on the cells.

DESCRIPTION: Hi Expert, Im having a issue to find a match by checking each character in a cell with raw data. please refer below : Input field : 73182999 1st Checking: If input field match exactly(all 8 digits) then return same value, if not checking continue by taking only first 3 character (731) and check the raw data, if found then it should move to next by taking 4 character(7318). if yes then move to 5th character ,let say if it fail to found the match during its 5th character(73182) then it has to return the 4th character (7318) and most largest found in the raw data with these 4 character prefix.

I have a list of names ranging from 2 to 20 characters, and I need a formula that separates out entries 9 characters or less. Currently I have =IF(LEN(A1)<=9,A1,"") but I want the false scenario to move the 10+ character string to another column or better yet a separate sheet.