Question about copying cell info

[Jafwiz]

I have a spread sheet that has 1 cell that has just random numbers and i need to copy that data to another cell a that has a words no formulas and add it to the front of the existing data? The first one has the way i need it to look the second is what i have to start with. So the first cell has a number now i have to add that same number to the front of the second cell. Is there a way to do this?

326879​

326879 BARR ARROW STRUCK COPPER OVERLAY

604664

BARR POLISHED BRS W/NIC RIB INSERT

 

[Candyman8019]

try the following assuming your data is in A1:B1:

=A1 & " " & B1

 

[Jafwiz]

try the following assuming your data is in A1:B1:

=A1 & " " & B1

Thanks for the response where do i but that ? I am not that good with Excel

 

[Candyman8019]

Wherever you want the full value to appear. C1 for example.

 

[Jafwiz]

Wherever you want the full value to appear. C1 for example.

I need the data in A1 to add to the line in B1 so it will look like line 1 that o sent? Also this sheet has 700 entry's and i need this to happen on all these cells? I tried to put that at the end of the sheet and nothing happened in b1 but when i copied the formula you gave me the cell shows

Internal ID Item Name/Number

 

[Candyman8019]

It sounds like your sheet may have headings in row 1. Try something like this:

Book1.xlsm
	A	B	C
1	Internal ID	Item Name/Number	Combined
2	604664	BARR POLISHED BRS W/NIC RIB INSERT	604664 BARR POLISHED BRS W/NIC RIB INSERT
Sheet7

Cell Formulas
Range	Formula
C2	C2	=A2 & " " & B2

 

[Jafwiz]

I copied that to the end of the sheet a and it made a new cell with just the right data my question is can i do the whole sheet all at once and is there a way to just change B2 to the new data?