| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to find and copy data
Hi,
I have the following data : 00101010014 Nov23h 0200CO0 0200CO01 0200CO0101 0200/61110091 00101020001 Max 0200CO0 0200CO01 O would like to insert a new column that will analise the first column data and between 00101010014 wil put th value 00101010014 likee this 00101010014 Nov 0200CO0 00101010014 0200CO01 00101010014 0200CO0101 00101010014 0200/61110091 00101010014 00101020001 Max 0200CO0 00101020001 0200CO01 00101020001 can somenoe help me? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to find and copy data
"Carpe Diem" wrote...
I have the following data : 00101010014 Nov23h 0200CO0 0200CO01 0200CO0101 0200/61110091 00101020001 Max 0200CO0 0200CO01 O would like to insert a new column that will analise the first column data and between 00101010014 wil put th value 00101010014 likee this 00101010014 Nov 0200CO0 00101010014 0200CO01 00101010014 0200CO0101 00101010014 0200/61110091 00101010014 00101020001 Max 0200CO0 00101020001 0200CO01 00101020001 .... Meaning you want to add the first token in the topmost cell as an ending token to all of these cells? If so, and if the original data were in A1:A6 and the revised data in B1:B6, B1: =A1&" "&LEFT(A$1,FIND(" ",A$1)-1) Fill B1 down into B2:B6. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to write function to find data in last row in 1 column | Excel Discussion (Misc queries) | |||
| Copy data from one worksheet to another using a function or a macr | Excel Worksheet Functions | |||
| Find & Copy Data query | Excel Discussion (Misc queries) | |||
| Can Excel Find and Copy a row of data? | Excel Worksheet Functions | |||
| HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions | |||
Hybrid Mode
