How to find a string in excel VBA

[Kaniguan1969]

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

[Bob Phillips]

Yes it is possible!

[SamT]

In VBA, go to Help (Press F1) then under "Visual Basic Language Reference" look at "Indexes/Lists" and "String Manipulation Keyword Summary"

In Excel Help (for formula functions), under "Function Reference," see "Text and Data Functions."

[Kaniguan1969]

Thanks SamT