Split text from one cell into columns

[oaky72]

Hello,

I have a lot of text in 1 cell that i need to split and move to other columns on the same row.

Using the example below, i need to take any text after the : and place it into separate columns. so NATHAN would be in 1 column, Age 6 in the next etc etc. Any help would be great. Thanks. Kevin

Childs Name/s: NATHAN Age: Age 6 Date of Party: 21st January 2017 Party Venue Address : JDR Karting - Gloucester, Unit 5, Madleaze Industrial Estate, Bristol Road, Gloucester GL1 5SG Start Time : 16.05 End Time : 18.00 RSVP Contact & by date: 077143333 (Sophie) Extra Comments (Max 15 words): Dress comfortably and warmly. The karts are suitable for children between 4-7 years old. How did you find us?: Google Would you like a proof? (Important): Yes. Email a proof copy to approve.

<colgroup><col></colgroup><tbody>
</tbody>

 

[oaky72]

Hi Eric,

Further to this what you provided, is it possible not to insert a row when splitting the text.

When i run the code the Headings remain in Row 1 but the text is in Row 3 with row 2 blank.

Secondly, is it also possible to add some code which would do a find and replace on all the text in every row. Was looking to find a comma and replace with | symbol.

Kind Regards.

Kevin