splitting a serial number to 2 lines based on a certain character 追蹤
I would like to know if there is an easy VB script that could split my GRN | Serial number from one line of text to two if a certain character is present?
For example, we have parts that have a GRN value and some parts have GRN and a Serial number.
Our Excel database sheet always has both combined but with a "|" character separator. So I want to have two separate lines of values on the Label, one for GRN and one for Serial Number with the script splitting it up when the "|" character is present.
Any help would be appreciated.