| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete then Concatenate
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Linear Mode
