Anyone good with Excel?
Ok, I am merging data from two columns with the formula =A2&&B2 in column C.
Now that works for line 2, but how do I make the formula work for every single ascending line, without manually changing the formula each time e.g. =A3&B3 etc?
Posted By: Hertz van Rental on October 22nd 2009 at 14:02:53
Message Thread
- Anyone good with Excel? (General Chat) - Hertz van Rental, Oct 22, 14:02:53
- double click on the bottom right corner of the cell with the formula in (General Chat) - Ralf Scrampton, Oct 22, 14:06:45
- Use "concatenate" (General Chat) - CB41, Oct 22, 14:06:45
- That's what the '&' means (General Chat) - BerlinCanary, Oct 22, 14:07:44
- Alright, alright, it was a typo! I'm no good with computers! STOP PICKING ON ME!!! (n/m) (General Chat) - Hertz van Rental, Oct 22, 14:09:00
- ok (n/m) (General Chat) - BerlinCanary, Oct 22, 14:10:45
- Alright, alright, it was a typo! I'm no good with computers! STOP PICKING ON ME!!! (n/m) (General Chat) - Hertz van Rental, Oct 22, 14:09:00
- using '&' is the same as using concatenate (n/m) (General Chat) - Ralf Scrampton, Oct 22, 14:07:33
- That's what the '&' means (General Chat) - BerlinCanary, Oct 22, 14:07:44
- Put =A2&&B2 into cell C2, click on the cell (General Chat) - Arizona Bay, Oct 22, 14:04:59
- Ah, thanks! (General Chat) - Hertz van Rental, Oct 22, 14:06:30
- ur welcm. (n/m) (General Chat) - Arizona Bay, Oct 22, 14:07:43
- Did you meat with a cocky sort in that London called Brian? (n/m) (General Chat) - BerlinCanary, Oct 22, 14:08:26
- I don't remember any Brians, but I didn't catch everybody's name. (General Chat) - Arizona Bay, Oct 22, 14:10:08
- He's a mate of mine (General Chat) - BerlinCanary, Oct 22, 14:14:51
- You' (n/m) (General Chat) - BerlinCanary, Oct 22, 14:11:18
- *meet* obviously (General Chat) - BerlinCanary, Oct 22, 14:09:00
- nah, just too much wrathage (n/m) (General Chat) - Ralf Scrampton, Oct 22, 14:09:55
- I don't remember any Brians, but I didn't catch everybody's name. (General Chat) - Arizona Bay, Oct 22, 14:10:08
- Did you meat with a cocky sort in that London called Brian? (n/m) (General Chat) - BerlinCanary, Oct 22, 14:08:26
- ur welcm. (n/m) (General Chat) - Arizona Bay, Oct 22, 14:07:43
- Ah, thanks! (General Chat) - Hertz van Rental, Oct 22, 14:06:30
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.