Delete then Concatenate

[Tempy]

Hi all, i have the following that i need to manipulate and do not know
how and am asking for some code please.

In cell B1 - for SAS > i must delete "for " and the space

I then need to concatenate B1, C1 & D1

Thanks in advance

Tempy

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

 

[Stefi]

In E1: =substitute(B1,"for ","",1) & C1 & D1

Regards,
Stefi


„Tempy†ezt írta:

 

[Tempy]

Thanks stefi, much appreciated

Tempy

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