PDA

View Full Version : How to find a string in excel VBA



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

Bob Phillips
09-04-2014, 12:53 AM
Yes it is possible!

SamT
09-04-2014, 02:39 AM
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
09-04-2014, 06:00 PM
Thanks SamT