Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing a formula with the actual string or number
I have separated a long list of addresses where the street number and street
name are all in one cell. Using FIND, LEFT/RIGHT, and REPLACE, I have now two columns, the first with the street number and the second with the street name. But I cannot sort because when I click on a cell, the formula is there, not the actual data. How do I get the real data in the cell so I can sort? -- Erik (a Word 2007 user) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting and replacing the first word in a String of text | Excel Worksheet Functions | |||
Replacing numeric X-axis labels with corresponding text string | Excel Discussion (Misc queries) | |||
I want to convert a formula to the actual number/verbage | Excel Worksheet Functions | |||
replacing codes with actual values | Excel Discussion (Misc queries) | |||
Replacing a random string of 5 numbers | Excel Discussion (Misc queries) |