Formula Not Found - Urgent!

[Harley D]

Hi ppl,

A B C D E F G
a s d f

I've tried =text(A1:G1,"GENERAL") in order to put together the value from
the prefered range but not working. So, I've to go trough using
=A1&B1&C1&D1&E1&F1&G1 to get "asdf" in cell A2.

Is there any formula that is much simple to use? Because there were more
cell to be occupied using the similar formula.

Thanks in advance.

 

[Bob Phillips]

NO, you have to do it that way as TEXT cannot work on an array, nor can
CONCATENATE.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Harley D]

Hi Bob,

If possible, please help me with custom functions

Sincerely

 

[Guest]

=A1&B1&C1&D1&E1&F1&G1
is about as simple as it gets.


Your first formula will not work as you have observed.
Nor will
=CONCATENATE(A1:G1)
work.

 

[Guest]

Here is a custom function for you...

Public Function Concat(ByVal CellRange As Range) As String
Dim rng As Range

For Each rng In CellRange
Concat = Concat & rng.Value
Next rng
End Function

You can use that in a spreadsheet as you want to...

=Concat(A1:G1)

 

[Harley D]

Thanks Jim,

Your given samples works better. That should heal my headace, and save me
alot.

Thanks again.

ps. Thanks to everyone who have respond to this message.