Excel VBA to copy certain data form a cell and past into empty cell

[kpost]

I am newer at creating VBa scripts. Need some help. I am working on creating a VBA script to copy data from a cell to another cell. Below is a sample data:

LIN**BP*6ZS52WA6AA~

SN1**2*EA*6~

So in this example the data that is in between the BP* ~ will be pasted in a separate cell. So the end result in the empty cell would be
6ZS52WA6AA
Similar to the data in between SN1** * * ~
The end result would be one cell would have 2 the next cell EA and the last cell 6.

 

[johnnyL]

I think your gonna need to provide some more examples so that some patterns can be found.

Right now, all I see is if a string that starts with 3 characters, followed by 2 asterisks (*) and then the next character is a number (#) then split that number and all remaining non '*' and '~' characters into separate cells.
And, if a string that starts with 3 characters, followed by 2 asterisks (*) and then the next characters are two letters and an '*' then copy the remaining characters up to the ~ into one cell.

 

[kpost]

na