Forum Discussion
Deleted
Aug 30, 2018NEED HELP WITH COMMAS, SPACES AND DELIMITERS IN A FORMULA
Hello! I need help understanding and fixing the formula for the attached examples. In the first example, the data in the first column is separated by a comma and a space. In the second example, the data is only separated by a comma and results in the information not being deposited into the correct columns to the right.
I would greatly appreciate any help with fixing this formula!
Thank you!
Hi Ronna,
In both cases you substitute comma and space ", " by spaces. You shall substitute separator only, i.e. comma and space in first case and comma only in second
=TRIM(MID(SUBSTITUTE($A26,",",REPT(" ",LEN($A26))),(B$3-1)*LEN($A26)+1,LEN($A26)))
Attached.
- Deleted
Thank you, Sergei! I appreciate your quick response and helpful answer.
Much appreciated!
Ronna :)
Ronna, you are welcome