Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation of Keystrokes in Populated Cells.
I am seeking a way, using an Excel macro, to automatically edit a collection
of cells in the following way. {F2} {Home} " ' " {Enter} Of course if there is a better way, I would be happy to learn that also. The issue is that I repeatedly copy data from a website data page, and paste it into an Excel 2000 spreadsheet. One of the collumns of data needs to be handled as text, but the characters a nn-nnn/nn where "n" is a number. When Excel in any way processes the characters as numbers, then the cell ceases to be informative of the intended label. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging only populated cells | Excel Worksheet Functions | |||
Cells to be populated from an workbook to another. | Excel Discussion (Misc queries) | |||
how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
select populated cells | Excel Programming | |||
Populated cells | Excel Programming |