Excel: How to keep the cell content without original formula?

Question

I want to keep the content of a cell (let's called it CELL), but CELL's content was generated by a vlookup formula referring to three other columns. I also want to delete those three columns but once I delete, the CELL will show Ref!

Answer 1

This one's pretty quick and easy. All you need to do is copy the contents of the cell with the formula and do a 'Paste Special' Check the box labeled 'Values' and the answer will be pasted, overwriting the formula. Then you can delete the other 2 columns.

Answer 2

As previously indicated, you can do it with a macro. This macro will trigger on the Worksheet_SelectionChange event. Copy this macro to the clipboard: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveSheet.Range("A5").Value = "" Then ActiveSheet.Range("A7").Value = "" Exit Sub End If ActiveSheet.Range("A7").Value = ActiveSheet.Range("A5").Value End Sub Select the worksheet you wish to implement it in and right click the sheet tab. Select 'View Code' Paste the macro into the worksheet module area. Close back to Excel. The macro will be triggered whenever a cell is selected.

For the best answers, search on this site https://smarturl.im/aDCMV

Answer 3

Good point!

You can keep the results by changing the characteristics of the cell.

Highlight the cells you want to change.

Right-click and choose 'copy'

Right-click and choose 'paste special'

Select 'paste values' from the choices.

After that, the formula will be gone, and the numbers will remain. You can delete columns at will!!! ;-)

Answer 4

You want to do a Copy and then Paste Special and paste as a value.

Take care,
Troy

Answer 5

Copy the cells you want the data from then right click and "Paste Special" then choose Values.

Answer 6

reverse phone number search compiles hundreds of millions of phone book records to help locate the owner's name, location, time zone, email and other public information.

Use a reverse phone lookup to:
Get the identity of an unknown caller.
Identify an area code.
Recall the name of a person whose number you wrote down.
Identify an unfamiliar phone number that shows up on your bill.
https://tr.im/721a7

Answer 7

I suggest this service: http://phonedetectives.co - The best reverse cell phone lookup service.

It's a cheap service that works great! It could be used for a much deeper search. You can use it to get hold of different varieties of background reports, and in addition cell numbers, addresses and names.. you can get unlimited reports... I ran with this because I required to verify more numbers.

You can get the name, other phone number, address history, relatives, and much more about anyone! The completly free reverse phone lookup generally doesn't provide anything interesting. To get interesting information, money will must be paid. The free searches don't provide considerably more than what may be found through the phone directory or personal information and they simply require your email to send spam. The reverse phone detective search tool does work, but you should use just the service that I posted above. The last thing you want to do, is pay for a service and find the numbers you want to lookup are not available in their directory.

The service that I reccomend doesn't have any kind of problem , you won't get any bad surprise! Trust it!

Reverse Phone Lookup area gives you additional access to millions of public records, including:

+ Find out the source of a harassing ("prank") caller
+ Research a number that appeared on your phone bill
+ Locate an old friend from high school or college
+ Research "missed calls" on your caller ID that you don't recognize
+ Verify an address
+ And more...

PhoneDetectives - http://phonedetectives.co

Conduct an instant reverse phone lookup. 100% Confidentail and Instant Results!