ExcelBanter - function to find and copy data

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - function to find and copy data (https://www.excelbanter.com/excel-worksheet-functions/152823-function-find-copy-data.html)

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?

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.