Use "concatenate"
Merge the data into a new column. Then you have to make the column format "text" (i think) and then you can fill down.
That's the gist of it really although I'd have to do it to remind myself of the exact procedure.
If no one else gets back to you, remind me and I'll do it
Posted By: CB41 on October 22nd 2009 at 14:06:45
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.