Carriage Return with a long string in Range() have ","

[Cuong Pham]

Hi everybody,
I want to carriage return in Range with a long string when meet ","

String : MOTU 0672355 / MOL V254308 / 40HC,TCNU 7836894 / MOL V254270 / 40HC

I use code but not sure:

Please Login or Register  to view this content.

Help me,
Many thanks.

[AB33]

But chr10 is Linefeed character, not comma

[Wormsek]

I don't know what do you mean by "carriage return", but maybe such UDF will be ok?

Please Login or Register  to view this content.

[Sanish Tirkey]

An Excel Function should work for you

=SUBSTITUTE(<<Cell Reference>>,",",char(10))

Let me know if this works

[Cuong Pham]

Thanks everybody very much ..........