Excel Macros & Me

Crashtard

I have an excel spreadsheet with about 4500 rows and 25-30 columns. One of the columns is an "Item" column. What I want to do is add a * to beginning of every cell in that column. Should I make a new column beside it with a * in every cell and try to combine them, or should I try to get a formula that just scans the Item column and adds the * to every entry? I don't care which method I use, as long as it will get the job done. The macros I've been able to find with google all deal with single rows of data, and I don't know how to apply those to every row. A formula and/or a how to would be super helpful. And.....go?

Sir Carcass

I would probably make a new column beside it then use the CONCATENATE formula. So like if you add a column A before your data that's in column B, it would be =CONCATENATE("*",B1). Then just drag that down as far as you need it. That should do the trick.

Crashtard

What I ended up doing was this: =""&D2&""&E2&"" It's not nearly as pretty as just using the concatenate, but it did what I wanted it to do. I found some formula's and basically cherry-picked what I needed to make it work . This thread can be locked/deleted.

Edit: Thanks for the reply Carcass. I definitely would have done that if I hadn't already rigged up that formula.