Break [|] pipe delimited values in rows

Closed
AJ - Apr 23, 2010 at 06:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 12:38 PM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 23, 2010 at 12:38 PM
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
0