Kaniguan1969
09-03-2014, 06:46 PM
Hi,
I have a requirements to find the string or cancatenate string in column A. Its possible to use excel vba or formula to do this. thank you.
Column A--------------
Label ---------------
ALV3000430iPH5S32SIL
DIR300XWHTSALV3003110REVERE3
FALV3000460iPH5S64GLD
ALV3003110VS985
PP3000440iPH5C16BLU
SALV3003110LUCID3
SALV3003110VS985
Column D--------------------E -----------F
Label --------------Label1-------Label2
--------------------------------
ALV3000430iPH5S32SIL-----iPH5S32SIL--iPH5S32SIL
DIR300XWHT---------------XWHT---------XWHT SALV3003110REVERE3-------REVERE3 ----REVERE3
FALV3000460iPH5S64GLD----iPH5S64GLD--iPH5S64GLD
ALV3003110VS985 ---------VS985 ------VS985
PP3000440iPH5C16BLU------iPH5C16BLU--iPH5C16BLU
SALV3003110LUCID3--------LUCID3------LUCID3
SALV3003110VS985---------VS985-------VS985
I have a requirements to find the string or cancatenate string in column A. Its possible to use excel vba or formula to do this. thank you.
Column A--------------
Label ---------------
ALV3000430iPH5S32SIL
DIR300XWHTSALV3003110REVERE3
FALV3000460iPH5S64GLD
ALV3003110VS985
PP3000440iPH5C16BLU
SALV3003110LUCID3
SALV3003110VS985
Column D--------------------E -----------F
Label --------------Label1-------Label2
--------------------------------
ALV3000430iPH5S32SIL-----iPH5S32SIL--iPH5S32SIL
DIR300XWHT---------------XWHT---------XWHT SALV3003110REVERE3-------REVERE3 ----REVERE3
FALV3000460iPH5S64GLD----iPH5S64GLD--iPH5S64GLD
ALV3003110VS985 ---------VS985 ------VS985
PP3000440iPH5C16BLU------iPH5C16BLU--iPH5C16BLU
SALV3003110LUCID3--------LUCID3------LUCID3
SALV3003110VS985---------VS985-------VS985