Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying info from two cells so that it is searchable later
I am trying to combine data from two cells, separated by a hypen (-) and
ending with -10-8. The resulting answer in the final cell would look like this 2-3-10-8. The 2 and the 3 are in separate columns so I created a formula that looks like this =(C81&"-"&D81&"-10-8"). It works like a charm except when I search for the data in the new cell (for instance 2-3-10-8), it does not recognize the 2-3-10-8 in the new cell so it says it can not find it. Is there a command that will convert the contents of the new cell into a format that can be read by the search tool??? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying info from two cells so that it is searchable later
Press Ctrl-F to bring up the serach dialog...
Click on Options In the Look-in drop-down choose Formulas Excel will search in Formulas also... "Tracy" wrote: I am trying to combine data from two cells, separated by a hypen (-) and ending with -10-8. The resulting answer in the final cell would look like this 2-3-10-8. The 2 and the 3 are in separate columns so I created a formula that looks like this =(C81&"-"&D81&"-10-8"). It works like a charm except when I search for the data in the new cell (for instance 2-3-10-8), it does not recognize the 2-3-10-8 in the new cell so it says it can not find it. Is there a command that will convert the contents of the new cell into a format that can be read by the search tool??? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
Need another Formula Help for Copying Info Between 2 Pages | Excel Discussion (Misc queries) | |||
copying info from on cell to several other cells several thousand | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Copying Info Into Numerous Cells | Excel Discussion (Misc queries) |