| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hopefully a simple macro to precatenate data in a column
Sorry if this is really easy or not possible. I'm a dba with very little
Excel experience. I've been given an Excel spreadsheet to import into a relational database there are some data consistency issues... Anyway, what I'd like to do is insert an underscore at the front of the data in each cell in a column - preferably in only those cells that have data. So if the cell has ABCDEF in it it'd become _ABCDEF . Any clues on how to accomplish this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to move to minimum value in column of data | Excel Discussion (Misc queries) | |||
| I need an Excel macro which will de-dupe a column of data? | Excel Discussion (Misc queries) | |||
| Macro to find the first cell in a column with different data | Excel Discussion (Misc queries) | |||
| Need to add data to the bottom of a column using macro | Excel Discussion (Misc queries) | |||
| Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
Threaded Mode
