Get instant live expert help on I need help with excel split cell by character
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How can i split a number in 1 cell by 30% 30% 30% and 10%?
Solved by C. F. in 30 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 display the result of an AutoFilter on column L (Sheet - Print Script - Column "Character" ) in cell C2. I only want the one character name selected by the filter to appear in C2. The other rows in the sheet still need to be filtered so the relevant info stays with the character name.
Solved by E. A. in 11 mins
Use the MID function in cell D14 to return the text " at merchant #" from the statement template in cell D9. Refer to the location of the "$" (in cell D12) - adjusted by adding 1 - as the "start_num" argument. Use the difference between the location of the "#" character (in cell D11) and the "$" character (in cell D12) as the "num_char" argument.
Solved by E. C. in 23 mins
Split text from cell into multiple columns
Solved by G. H. in 18 mins