Thread: joining two columns together
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Scoops Scoops is offline
external usenet poster
  
Posts: 108
Default joining two columns together

wrote:
Hi there,

I have a series of text data in one column and a series of figures in
another column. I want to join them together to create one column (i.e.
GH in column A and 4589 in column B will produce GH4589)

I'm trying to think of ways of doing it but my knowledge is very
limited. I am however good at copying and pasting code......Can anyone
help?

Chris

Hi Chris

Does it have to be code?

The formula

=A1&B1

will do the trick

Regards

Steve

Reply With QuoteReply With Quote