Adding a space after a hex character

[jaango123]

Hi ,

I have this hex text in sheet1, first cell. Can anyone tell me how can i add a space after every two characters and dump the same into sheet2, first cell? I put a sample of the starting of data in sheet2. Is there any formula in excel? Sheet attached. Thanks for all the help as always.

[sweep]

Hi,

This bit of code should do what you ask.

Please Login or Register  to view this content.

[snb]

Since you posted in the programming subforum i'll give you a VBA approach.

Please Login or Register  to view this content.

[jaango123]

Awesome. Thanks for the quick responses. That answered my problem