Split text string with semicolon

Please review the forum rules concerning titles and why we like to see meaningful ones. As this is your first post I've changed it for you
RB

I have a several rows of 32 digit numbers only in the first column of excel sheet.I want to put semicolon after every 2 digits.
Plz provide me a simple and a quick solution.

This routine will insert a semicolon after every 2 digits. Formatted the column as text for this. See attachment

Please Login or Register  to view this content.

Hi,

There's no doubt a string slicing array formula which I'll have a think about but a way which avoids VBA is to select the whole column and use Data Text To Columns and choose fixed width to split the string up into 16 columns of two characters. Now in a new column concatenate all those 16 column with a ";" in between.

A bit messy and there will no doubt be a simple(?) array formula coming along....