Question posted by hamzachuk on August 17th, 2022
In Excel, How Can I Split A Text Saparated With Commas Using Functions?
In excel, how can i split a text saparated with commas using functions?
Current Answers
Answer #1: Posted by SonuKumar on August 17th, 2022 9:19 PM
SonuKumar
Member since:
May 9th, 2021 Points: 16,604,600
Member since:
May 9th, 2021 Points: 16,604,600
Download the following Excel file for your practice.
Splitting String by Comma.xlsx.
=LEFT(B5,FIND(",",B5)-1)
=MID(B5,FIND(",",B5)+1,FIND(",",B5,FIND(",",B5)+1)-FIND(",",B5)-1)
=RIGHT(B5,LEN(B5)-FIND(",",B5,FIND(",",B5)+1))
=TRIM(MID(SUBSTITUTE($B5,",",REPT(" ",LEN($B5))),(C$4-1)*LEN($B5)+1,LEN($B5)))
https://www.exceldemy.com/excel-split-string-by-comma-formula/
Please respond to my effort to provide you with the best possible solution by using the "Acceptable Solution" and/or the "Helpful" buttons when the answer has proven to be helpful.
Regards,
Sonu
Your search handyman for all e-support needs!!
Answer #2: Posted by freginold on August 17th, 2022 1:20 PM
freginold
Member since:
December 20th, 2011 Points: 23,253,885
Member since:
December 20th, 2011 Points: 23,253,885
This Microsoft support page describes how to do exactly that:
https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-functions-49ec57f9-3d5a-44b2-82da-50dded6e4a68
https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-functions-49ec57f9-3d5a-44b2-82da-50dded6e4a68
Similar Questions
Excel Unable To Read File
I have a problem with MS Excelthe program shows an error: "Excel unable to read file" , what to do?
I have a problem with MS Excelthe program shows an error: "Excel unable to read file" , what to do?
(Posted by JuneRM 6 years ago)
?corrupt Word File - Says To Use Text Converter
Hello, I have been reading some posts about you to repair a file and it says to use the text convert...
Hello, I have been reading some posts about you to repair a file and it says to use the text convert...
(Posted by reubenmurray 8 years ago)
I Cannot Save Excel Files On My System , Why ? I Use Office 2010
(Posted by palmerrs 10 years ago)
Convert The Attached Excel Spreadsheet
How do a I convert the attached Excel spreadsheet into a beautiful Excel Form?I am using Microsoft o...
How do a I convert the attached Excel spreadsheet into a beautiful Excel Form?I am using Microsoft o...
(Posted by HrikteshK 10 years ago)