PC Review


Reply
Thread Tools Rate Thread

Combine Data From 2 Columns into 1

 
 
=?Utf-8?B?RGFzaGE=?=
Guest
Posts: n/a
 
      4th Nov 2006
I have just learnt how to Combine Data from 2 cell's into One It woked great
while I practiced on a list of info It works until I try and Drag down to
install (fill) all the other Names and Numbers in that column of Data into
the new One eg Name and Numbers, I am doing the Formula and then hitting
enter and they join and then I wait and select the + and drag down but only
the original is copied not all the others Eg: =D822&", "&C822 Enter; It
works for that first Name and Number But when I drag down to enter and Join
all the others it just Drags the initial name and Number, I am a Newbie any
help would be appreciated thank you Dasha
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
Guest
Posts: n/a
 
      4th Nov 2006
What do you have in the cells that work and the cells that don't work?

"Dasha" wrote:

> I have just learnt how to Combine Data from 2 cell's into One It woked great
> while I practiced on a list of info It works until I try and Drag down to
> install (fill) all the other Names and Numbers in that column of Data into
> the new One eg Name and Numbers, I am doing the Formula and then hitting
> enter and they join and then I wait and select the + and drag down but only
> the original is copied not all the others Eg: =D822&", "&C822 Enter; It
> works for that first Name and Number But when I drag down to enter and Join
> all the others it just Drags the initial name and Number, I am a Newbie any
> help would be appreciated thank you Dasha

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine columns of data into one Naruto Microsoft Excel Charting 2 17th Dec 2007 03:53 PM
How to combine 2 data columns? =?Utf-8?B?c2ltc2py?= Microsoft Access Form Coding 1 8th Dec 2004 12:47 AM
How to Combine Data in Several Columns? (How it should look like in the end?) hce Microsoft Excel Misc 5 12th Mar 2004 02:24 PM
How to Combine Data from Several Columns? hce Microsoft Excel Misc 10 2nd Mar 2004 03:42 PM
How to Combine Data in Different Columns hce Microsoft Excel Misc 1 28th Feb 2004 07:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:25 PM.