search for text and add text at the end

[GlennY]

Is there a way that i can search a column that contains the following text sv00 and have the word GLOBAL ZONE follow the entire text?

For example, if column A contains pahesv00app, i would like it to read pahesv00app GLOBAL ZONE

i have a spreadsheet with 25k rows and there are multiple combinations of text that contain sv00

 

[moonfish]

If you need this 'GLOBAL ZONE' to be appended within the same cell you'll need VBA (which I'm not particularly good at) but if you'll settle for an adjacent cell, do this:
=IF(ISNUMBER(SEARCH("*sv00*",A1)),"GLOBAL ZONE","")

This assumes your code is in A1.

 

[sheetspread]

=IF(FIND("sv00",B4,1)>0,B4&" GLOBAL ZONE")

 

[GlennY]

thanks all. I got it to work