| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reformation after CONCATENATE procedure Q.
Put the columns back Select your concatenate formulas and hit the Copy button Then go to the menu and Click Edit Paste Specials In the Paste Special dialog box, choose values. This will overwrite the formulas with the values that were produced by the formulas, so you can now delete the original data. -- Lilliabeth ------------------------------------------------------------------------ Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741 View this thread: http://www.excelforum.com/showthread...hreadid=499046 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
| execute stored procedure from excel | Excel Worksheet Functions | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Threaded Mode
