| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Macro to copy part of text in cell
Hi,
I want to adapt a file of output from SAP. Column B contains text in each cell of which I want to cut and paste the first part to Column A. The rest of the text in Column B has to remain there. Can anyone help me? Thnx! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use Macro to copy part of text in cell
Think we need to know how to recognize what is to be saved in each location
ie separated bye a space or some special character? -- David "PhilipsBernard" wrote: Hi, I want to adapt a file of output from SAP. Column B contains text in each cell of which I want to cut and paste the first part to Column A. The rest of the text in Column B has to remain there. Can anyone help me? Thnx! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use Macro to copy part of text in cell
Text in column B is formatted either as:
three spaces followed by "WW01xx" followed by six spaces followed by text (which needs to remain in column B), or '*' followed by two spaces followed by "xxxxxxx" followed by six spaces followed by text (which again needs to remain in Column B). I'd like to have the "WW01xx" values and the "xxxxxxx" numbers in column A and the text in column B. Is this possible? Thnx 4 reply! "David" wrote: Think we need to know how to recognize what is to be saved in each location ie separated bye a space or some special character? -- David "PhilipsBernard" wrote: Hi, I want to adapt a file of output from SAP. Column B contains text in each cell of which I want to cut and paste the first part to Column A. The rest of the text in Column B has to remain there. Can anyone help me? Thnx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
| excel - create a macro to use cell text as part of a file name | New Users to Excel | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Macro to copy text upon entry into cell | Excel Programming | |||
| Macro to copy text to a specific cell reference | Excel Programming | |||
Linear Mode
