save results from formula in Excel?

[Mconvard]

Is there a "save results of" command in Excel? For example I have an inventory where I save both the number and name of a machine. The machine name being the same as the number with the addition of a code for its location. eg 1234, then xx-1234. I use concatanate to combine 2 fields but to keep the results i have to export the column to note pad and then return it to excel as text. Is there a simpler way to do this?
thanks
Maurice

 

[mikevh]

1. Right-click the column with the formulas, and
choose "Copy".

2. Right-click the column again, and choose
"Paste special"

3. Choose "values" and click OK. This will replace
the formulas in the column with their values.

Also, you may want to use "&" for concatenation rather
then the "concatenate" function. Much less typing. e.g.

"=a1 & b1", vs. "=concatenate(a1,b1)"

 

[DaleWatson123321]

Maurice,

If xx is in Column A, and 1234 is in Column B, enter the following formula in Column C.

=A1&B1

Copy the formula down for the number of rows required.

To convert the formulas to values, Highlight the formulas, and then use: Edit - Paste Special - Values.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[PepeLeMokko]

Or to convert formulas to values, select the range of formulas, go with your cursor to the top of the selection and when it chages to an arrow, drag the range around with the rignt button pushed down ( like when you are dragging)and put the range back wherever you want ( even the same place).
A menu will pop up, and select " copy here as values only"

 

[Mconvard]

Thanks all, Useful and quick!

 

[DaleWatson123321]

Okay... just for the benefit of the "KEYBOARD IS (MUCH) FASTER THAN THE MOUSE" side ...

1) To highlight the range of formulas...
While holding down the <Shift> key, hit the <End> key, followed by the <Down-Arrow>.

2) To copy... hold down <Control> and hit C

3) To paste values... hit: <Alt> E S V and <Enter>

For such a common, often used procedure, one can:
a) get very used to using this &quot;keyboard-shortcut&quot; method,
b) save considerable time over the use of the mouse,
c) gain more familiarity with the keyboard,
d) increase your finger dexterity.



Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[KenWright]

And depending on how really lazy you are you might prefer a macro that will let you do it in one hit if assigned to a keyboard combo.

Sub PasteValues()
' Keyboard Shortcut: Ctrl+Shift+P
'
With Selection
Selection.Copy
Selection.PasteSpecial Paste:=xlValues
End With
Application.CutCopyMode = False
End Sub


Regards
Ken.........