excel concatenate

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

drafter

Thread Starter
Joined
Nov 21, 2000
Messages
419
I have excel 2003 and I have concatenated a bunch of cells in to cell A2". I can now right click the contents of A2 drag and drop them as values to A3... but I would like to eliminate the step of dragging and droping so I made cell A3 "=value(A2)". This does not seem to work I get the error #VALUE! in cell A3. Can anybody tell me how to do this?

thanx
 
Joined
Jul 1, 2005
Messages
8,546
drafter said:
I made cell A3 "=value(A2)". This does not seem to work I get the error #VALUE! in cell A3.
I don't -- but I'm only guessing at the kind of values you might be using. Please give more detail (e.g. cell 1 contains x, cell 2 contains y, what the A2 formula is, etc.).
 

drafter

Thread Starter
Joined
Nov 21, 2000
Messages
419
This is my formula "=CONCATENATE(DATA!A2,"-",DATA!B2,"-",DATA!C2," - ",DATA!D2,DATA!E2,DATA!F2,DATA!G2)" Im actually taking data from another page called DATA... I was just trying to keep my question as simple as possible. All my data is just text.
 
Joined
Jul 1, 2005
Messages
8,546
A2/B2/C2 are to make up a date? What's in D2/E2/F2/G2?

Or if you prefer, what do you get with =TEXT(A2,"") ?
 

drafter

Thread Starter
Joined
Nov 21, 2000
Messages
419
thans for your time bomb #21 but =TEXT(A2,"") does not paste as a value. Here is what is in the 7 fields... I have them seperated by hyphens. They are names of drawings broken down into 7 columns and now I want to put them back together.

This is what is in the columns:
A1-34947-KT-4-240 - STUDBLAST - 7.5 TON OVERHEAD CRANE ELECTRICAL CONTROL SCHEMATIC

thanx
 
Joined
Jul 1, 2005
Messages
8,546
I'm afraid I don't get "paste as a value". The only way to paste as a value is to, err, paste as a value. A formula won't achieve that. Hopefully someone else will be able to figure what you're actually after.

Regrets,
Andy
 
Joined
Jul 25, 2004
Messages
5,458
You either want a formula or a value.

To use a formula to show whatever is in cell A2, use ...

=A2

To paste only the values of what is in cell A2 ...

Select A2
Press Ctrl + C
Press Alt + E, S, V (That's Alt + E simlutaneously, then touch S, then touch V, then Enter)

HTH
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top