Club PA 2.0 has arrived! If you'd like to access some extra PA content and help support the forums, check it out at patreon.com/ClubPA
The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

Excel Macros & Me

CrashtardCrashtard Registered User regular
edited December 2008 in Help / Advice Forum
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?

I pinky swear that we will not screw you.

Crashtard.jpg
Crashtard on

Posts

  • Sir CarcassSir Carcass I have been shown the end of my world Round Rock, TXRegistered User regular
    edited December 2008
    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.

    Sir Carcass on
  • CrashtardCrashtard Registered User regular
    edited December 2008
    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.

    Crashtard on
    I pinky swear that we will not screw you.

    Crashtard.jpg
Sign In or Register to comment.