Break [|] pipe delimited values in rows

Closed
AJ - 23 Apr 2010 à 06:22
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Apr 2010 à 12:38
I have a text line containing information separated with pipe sign [|].
Kindly provide me a macro/code to break them into:
a. Each broken value should be moved to a new row downwards.
Or [Optional]
b. Multiple cells towards right.

Sample:
Column 1 / Row1
W: www.hintonburdick.com
NM: Robert Cox, CPA|NM: Todd Hess, CPA|NM: Jim Wilson, CPA

a. Should be:

Column 1 / Row1
W: www.hintonburdick.com
Column 1 / Row2
NM: Robert Cox, CPA
Column 1 / Row3
NM: Todd Hess, CPA
Column 1 / Row4
NM: Jim Wilson, CPA

b. OR [Optional]

Column1 / Row1
W: www.hintonburdick.com
Column2 / Row1
NM: Robert Cox, CPA
Column3 / Row1
NM: Todd Hess, CPA
Column4 / Row1
NM: Jim Wilson, CPA
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Apr 2010 à 12:38
This seem to be a continuation of your previous query. see this

https://ccm.net/forum/affich-325807-combine-data-of-multiple-cells-into-one-cell#9