Use part of string

[Tempy]

Hello all, i have a string and need to extract the Supplier name.
"GR extract for SAS Automotive RSA (Pty) Ltd"
I need to remove the "GR extract for " as this is constant and the rest
is variable in length, dependant on the supplier name.
Could somebody please help me with some code.

Thanks for the help in advance

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[raymond.allan]

A quick and dirty way is:

Cells.Replace What:="GR extract for ", Replacement:="", LookAt:=xlPart,
_
SearchOrder:=xlByRows, MatchCase:=True

HTH
Raymond

 

[Stefi]

Hi Tempy,

=SUBSTITUTE(A1;"GR extract for ";"")

supposed your original text is in cell A1.

Regards,
Stefi


„Tempy†ezt írta:

 

[Tempy]

Hi Stefi, danke, but as i am not a programme, could you please explain
how i would use as i have tried it by saying myValue = Substitute(A1,
"GR extract for ", "") and then i get an error message ?
I know you are in Germany, as the "," in South Africa is replaced by the
";" in germany.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

Stefi's is a worksheet formula, just plug it into the sheet.

 

[Stefi]

Or, if you need the return value in a VBA variable, use it like
myValue = WorksheetFunction.Substitute(A1,"GR extract for ", "")

Stefi


„Bob Phillips†ezt írta: