Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |