formula for non-sequential columns

[[email protected]]

I've got data in columns separated by two other columns. I wish to
create a formula in another column that will include the data from
these two non-sequential columns. How do I do this?

Ex: data are found in columns G(rows 1) and J(rows1) and would like to
create formula which lists such data in column S in the following
order: info from column G, row 1 then info from column J, row 1.

Thank you for any assistance. I've pulled out most of what hair I've
got left over this.

[bgeier]

in column "S"

=G1 & J1

[Pete_UK]

I think this is what you want - enter this formula in S1:

=G1&", "&J1

This will put a comma and a space between the two items.

Hope this helps.

Pete

[[email protected]]

i apologize for the error. i meant to indicate that I wish the info
from the two columns to be included in column S accordingly:

info from column G, row 1 to be inserted in column S, row 1; and info
from column G, row 1 to be inserted in column S, row 2.

thanks again.

[email protected] wrote:
> I've got data in columns separated by two other columns. I wish to
> create a formula in another column that will include the data from
> these two non-sequential columns. How do I do this?
>
> Ex: data are found in columns G(rows 1) and J(rows1) and would like to
> create formula which lists such data in column S in the following
> order: info from column G, row 1 then info from column J, row 1.
>
> Thank you for any assistance. I've pulled out most of what hair I've
> got left over this.

[Pete_UK]

Ok, enter these formulae in the cells shown (I think you have a typo):

S1 =G1
S2 =J1

Hope this helps.

Pete