Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reply to Skip Vought re merging

Status
Not open for further replies.

kinselas

IS-IT--Management
Aug 4, 2002
60
AU
What I want to do is combine 2 columns into one. The account number is split into 2 columns which ought to be combined into one . it was sent as a text file originally
 
Make column C

=Concatenate(A1,B1)

I like to stick something between sometimes, and the concatenate function can be overloaded, like..

=concatenate(a1,"-",b1)

Rusty

The early bird gets the worm, but the second mouse gets the cheese.
-------------------------------------
92.5% of statistics mean nothing.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top