| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| URGENT HELP - SUM FORMULA | Excel Worksheet Functions | |||
| Formula have a VLOOKUP but want it to =0 if no value is found | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| URGENT -- search in string for a value in another column, if found, return value from next column | Excel Programming | |||
| Formula to identify what was NOT found | Excel Worksheet Functions | |||
Linear Mode
