Excel: one number into 3 in the same column

[revo2001]

I have a large amount of numbers that I need I need to convert into 3 numbers each and keep the numbers in the same column.

I already have the numbers actually in 3 separate columns, but to insert them into my mysql database, they need to be in the same column.

Pretty much its an ecommerce store and I'm trying to import pricing for three different variations of one product.

Man I hope I am describing this correctly.

Pretty much to get this into the database i have to have the numbers like this:

1 6
2 12
3 24
1 3
2 6
3 12
1 5
2 10
3 20

Any help would be greatly appreciated! I've been trying to figure out a good formula for the past couple hours. :\

 

[Whatsisname]

if()

 

[Usquabach]

i'm not sure if i'm understanding right but it sounds like you need to use concatenate()

the command will take numbers, text, etc and join them into a single column. for example

if A1= 1, B1 = 2, C1 = 3

then if you paste =concatenate(A1, B1, C1) into D1 the cell will contain 1 2 3

 

[TechieSooner]

^^^ yep, concatenate would be my first impression given the information you've given.

 

[Pez]

Using the previous example:
A1= 1
B1= 2
C1= 3
(where the value is " #" and stored as text)
D1=concatenate(A1,B1,C1) will display " 1 2 3"

If you keep the values as numbers, D1=concatenate(" ",A1," ",B1," ",C1) will also display " 1 2 3"
If you keep the values as numbers, D1=(" "&A1&" "&B1&" "&C1) will also display " 1 2 3"