Being able to search what a formula produces

[methodx]

Hello,

I am working in an Excel spreadsheet with some 9 digit numbers. Th
original document has the first 7 digits in one column, and the fina
two digits in a different column.

I need them to be together in one column as one number, but I didn'
want manually go down each row, so I concatenated the two columns.

However, now in the third column (with the full 9 digit number)
cannot search and find a specific number. I believe the reason is, th
numbers do not exist in this column, rather a formula does tha
conactenates the other two columns. How do I make the actual number
exist in this column and make them searchable?

Thanks in advance for the help

 

[Niek Otten]

Look in the options in the dialog for Find and Replace; you can choose
between searching formulas or values.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[methodx]

Ok, thanks. I also figured out that I can copy my 9 digit column an
then paste it using "paste special" and selecting "values".

Thanks for the help