Do you have other text linked to other numbers?

If so then you could use VLOOKUP. E.g list the text in one column, e.g. in
D1:D10 list "Melrose Place IL" and whatever other text you might have. In
corresponding rows in E1:E10 put your numbers, e.g. in E1 2.10

then assuming you type text into A1 and want the number to appear in B1, use
this formula in B1

=VLOOKUP(A1,D1:E10,2,0)



"hoopstrk" wrote:

Is there a formula that I can use to automatically put in a number in one
cell if I type a specific text in another cell. Example: If I type the word
Melrose Park IL in one column can I use a formula that will automatically put
in 2.10 into another column?