Formula Not Found - Urgent!
 

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.

Formula Not Found - Urgent!
 

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" <[email protected] wrote in message
...
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.

Formula Not Found - Urgent!
 

Hi Bob,

If possible, please help me with custom functions

Sincerely

"Bob Phillips" wrote in message
...
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" <[email protected] wrote in message
...
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.

Formula Not Found - Urgent!
 

=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.
--
Regards,
Tom Ogilvy


"Harley D" wrote:

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.

Formula Not Found - Urgent!
 

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)
--
HTH...

Jim Thomlinson


"Harley D" wrote:

Hi Bob,

If possible, please help me with custom functions

Sincerely

"Bob Phillips" wrote in message
...
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" <[email protected] wrote in message
...
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.

Many Thanks
 

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.

"Jim Thomlinson" wrote in message
...
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)
--
HTH...

Jim Thomlinson


"Harley D" wrote:

Hi Bob,

If possible, please help me with custom functions

Sincerely

"Bob Phillips" wrote in message
...
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" <[email protected] wrote in message
...
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.