Excel & consolidate??

  • Thread starter Thread starter Steve Geary
  • Start date Start date
S

Steve Geary

Hi Guys,

I am new to Excel, sorry!!!

in 'a1' I have 'john'
in column 'b1' I have 'smith'

How can i make column 'c1' show 'john smith'???


I thought it was 'consolidate' but I just cant fathom it!!!

Cheers

Bob
 
Steve Geary said:
Hi Guys,

I am new to Excel, sorry!!!

in 'a1' I have 'john'
in column 'b1' I have 'smith'

How can i make column 'c1' show 'john smith'???


I thought it was 'consolidate' but I just cant fathom it!!!

Cheers

Bob
Click to expand...

=A1&" "&B1
 
=CONCATENATE(A1," ",B1)

Example from Excel Help

Suppose in a stream survey worksheet, C2 contains "species", C
contains " brook trout", and C8 contains the total 32.

CONCATENATE("Stream population for ",C5," ",C2," is ",C8,"/mile"
equals "Stream population for brook trout species is 32/mile"


Hope this help
 
Thanks for help guys. Movinging on a little from that,. How about if
column 'a' has all 'first names' and column 'b' has the 'Surnames'? Column
'c' then needs to contain the first & surname. There are over 1500 names I
need to sort here!!!

Cheers

Bob
 
Sorry. You would get #VALUE! if there was only one first name in A1.
Instead, try this:
=IF(ISERROR(FIND(" ",A1)),A1&" ",LEFT(A1,FIND(" ",A1)))&B1
 
brilliant mate. Thanks


cheers

Bob


Paul said:
Sorry. You would get #VALUE! if there was only one first name in A1.
Instead, try this:
=IF(ISERROR(FIND(" ",A1)),A1&" ",LEFT(A1,FIND(" ",A1)))&B1
Click to expand...
 
Back
Top