ExcelBanter - Delete then Concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Delete then Concatenate (https://www.excelbanter.com/excel-programming/338929-delete-then-concatenate.html)

Tempy

Delete then Concatenate

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

Delete then Concatenate

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

Regards,
Stefi

€žTempy€ ezt Ã*rta:

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 ***

Tempy

Delete then Concatenate

Thanks stefi, much appreciated

Tempy

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

All times are GMT +1. The time now is 03:00 AM.