Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return a portion of data entered into a cell
Ex: say I enter the following into cell A1: "1400 jefferson" When i
select this data from a drop down list, I do not want all of the "1400 jefferson" going into the cell, rather I want just to return the number portion of that data "1400" what formula can do this. Thank you, Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
return a portion of data entered into a cell
If your data is always of the form {number space text}
then use the formula: =LEFT(A1,FIND(" ",A1)) This gets you everything to the left of that space. -- Gary's Student "Brian" wrote: Ex: say I enter the following into cell A1: "1400 jefferson" When i select this data from a drop down list, I do not want all of the "1400 jefferson" going into the cell, rather I want just to return the number portion of that data "1400" what formula can do this. Thank you, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data changes when entered into a cell | Excel Worksheet Functions | |||
I need to search for then extract a specific portion of cell data... | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |