View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carpe Diem Carpe Diem is offline
external usenet poster
 
Posts: 28
Default 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?