Get instant live expert help on I need help with excel split string by character

“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
Possibly creating some code string formula to help split jumbled data, hard to explain
Solved by T. J. in 19 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
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
How can i split a number in 1 cell by 30% 30% 30% and 10%?
Solved by C. F. in 30 mins