TexasCHLforum.com

Is there a way to "import" information from 3 cells one sheet of an Excel spreadsheet to a single cell on another sheet? My online class registration captures names in three separate fields (first, last, MI) and I need to combine all of that data into one input sheet for the automated CHL-100 and CHL-8. To complicate matters, I need to add a comma so I can present it as "last, first, middle initial" in the one data input cell.

I've searched and can't find anything. Can this be done? If not, revising the automated CHL-100, CHL-8 is going to be a major project.

Thanks,
Chas.

If you had the last name in column A, the first name in column B, and the middle intial or name in column C, it would be like this:

=A2&", "&B2&" "&C2

- Jim

good job!

If I needed perform a DIY knee surgery, I'm convinced I could get you guys to tell me how to do it!

Thanks Jim,
Chas.

You're welcome. I'm glad I could help.

- Jim

Start with a 1911, aim at knee, pull trigger, put in new replacement knee.

Keith B wrote:Start with a 1911, aim at knee, pull trigger, put in new replacement knee.

ouch

There's also a concatenate function in Excel but i usually use the method seamusTX showed.

Keith B wrote:Start with a 1911, aim at knee, pull trigger, put in new replacement knee.

You're supposed to take a shot of whiskey and hold a bullet between your teeth before you do that.

bayouhazard wrote:There's also a concatenate function in Excel but i usually use the method seamusTX showed.

Concatenate is my favorite function for this type of data gathering. What can I say, I'm a geek...

To paraphrase Einstein, everything should be as simple as possible, but no simpler.

Actually I would bag Excel and use OpenOffice, but the technique would be the same. It's nearly the same as VisiCalc 1.0 and Lotus 1-2-3.

- Jim

seamusTX wrote:To paraphrase Einstein, everything should be as simple as possible, but no simpler.

Actually I would bag Excel and use OpenOffice, but the technique would be the same. It's nearly the same as VisiCalc 1.0 and Lotus 1-2-3.

- Jim

Does that still exist? That was the only spreadsheet program choice when I took my MIS classes back in the 80's. Pre Excel popularity.

I don't know if Lotus 1-2-3 will run on a current version of Windows. I haven't seen it anywhere since maybe 1990. According to the googles, its successor is an IBM product called Lotus SmartSuite.

- Jim

If you want a current alternative, Google Doc's works pretty well. But no other product has all the features of Excel for really advanced formulas.

You can also use the =CONCATENATE function in Excel
CONCATENATE(text1,text2,...)
Argument
Description
text1,text2,...
1 to 255 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
General remarks
The "&" operator can be used instead of CONCATENATE to join text items.
Example
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1
2
3
4
A B
Data
brook trout
species
32
Formula Description (Result)
=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile") Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile)