LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
trying to write function to find data in last row in 1 column belvy123 Excel Discussion (Misc queries) 1 January 20th 07 01:58 PM
Copy data from one worksheet to another using a function or a macr Sweetetc Excel Worksheet Functions 0 April 3rd 06 08:21 PM
Find & Copy Data query bbibib Excel Discussion (Misc queries) 3 February 9th 06 06:35 PM
Can Excel Find and Copy a row of data? Still Learning Excel Worksheet Functions 0 September 20th 05 10:06 PM
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA hsg Excel Worksheet Functions 2 November 18th 04 07:24 AM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"