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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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.
Solved by E. E. in 25 mins
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
Solved by I. W. in 16 mins
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.
Solved by A. S. in 15 mins
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.
Solved by S. S. in 18 mins
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.
Solved by D. B. in 22 mins