Find/Replace

L

Libby

I have a column of 3600 IDs that I need to find and replace in a table that
has 4 columns and 18000 rows. What kind of a formula that I can create to do
this.
 
S

Shane Devenshire

Hi,

Please show us a small sample of the data in the column and in the table and
explain using that what you want.
 
L

Libby

These are the records that need to be found

ID CO Type Amount
01890005 405 GAAP 1111.79
01890006 405 GAAP 1615.40
01890007 405 GAAP 4145.56
0243005 110 GAAP 9073.60
025115 110 GAAP 2987282.48
02530024 110 GAAP 37516.00
0250029 110 GAAP 55206.07
2540083 110 GAAP 2620.96
2560038 110 GAAP 9991.69

The following records are the data that they need to be replaced in

ID Co Amount
1874902 110 266466.34
1874903 100 11837.26
1874904 110 46041.97
1874905 110 750.00
1874906 110 13257.74
1874907 100 2788.00
1874908 110 19622.84
1874909 110 13254.00
1890005 405 1111.79
1890006 405 1615.40
1890007 405 4145.56
2430055 110 9073.60
2510015 110 2987282.48
2530024 110 37516.00
2540029 110 57830.10
2540083 110 2607.86

The only difference between the ID's is that the leading 0 is missing in the
data and needs to be added
 
S

Sean Timmons

OK, you'll want to use helper columns then.

In, say, Column E, format as text and type ="0"&A2 and paste down.

then, copy and paste this new column on top of your existing column A. Make
sense?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for calculating YTD values 3
How do I find & replace pieces of a formula? 4
If formula using 2 or more columns 1
comparing more then one column with numbers and letters 1
VBAscript for data matching excels 0
Concentration Analysis 3
Count range of cells if not next to each other 0
Need help comparing 2 columns of number to find unique numbers 3

Top