Break [|] pipe delimited values in rows [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!