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, th...
SergeiBaklan
Aug 30, 2018Diamond Contributor
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.
- DeletedAug 30, 2018
Thank you, Sergei! I appreciate your quick response and helpful answer.
Much appreciated!
Ronna :)
- SergeiBaklanAug 30, 2018Diamond Contributor
Ronna, you are welcome