add under score before 4 digit numbers

is there a simpler logic and way?

sorry, i'm new, was unaware of the rules

Trie this

Please Login or Register  to view this content.

function:

Please Login or Register  to view this content.

Originally Posted by G e r a r d

Trie this

Please Login or Register  to view this content.

function:

Please Login or Register  to view this content.

its not working as exactly i want it to work.

it adds underscore before any cluster of characters that has more than 4 digits together..

i want underscore only before cluster that has exactly 4 digits together

Modified fuction will only add _ to first cluster of 4 numbers

Please Login or Register  to view this content.

Originally Posted by venkatpvc

if your string always the same you can use this code. but its not goint work if your data has diffrent types
this code assumes that you data in column A and result will be column B

Please Login or Register  to view this content.

these are working but only for one cluster of numbers in a string..

like if the string is abdsf3456asdfg5678as
so this code is converting to abdsf_3456asdfg5678as
but i want it to be like this abdsf_3456asdfg_5678as

Originally Posted by G e r a r d

Modified fuction will only add _ to first cluster of 4 numbers

Please Login or Register  to view this content.

this is also adding underscore at the starting of the string and adding only one underscore for only one cluster, what if there are multiple cluster?
i'm new to this vba, so i'm not able to understand your code, however i will be happy if it serves my purpose

Originally Posted by venkatpvc

Please Login or Register  to view this content.

this is fine but, it is converting this to 1904758968
_1904_758968