| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(ISTEXT Concatenate formula question
Excel 2007
I have a formula that concatenates cells if they have text and inserts ";" between each text string. However, it also puts multiple ;;; at the end if there was no text in the last 3 cells. What, if anything can I tweak to prevent this? =IF(ISTEXT(V3),V3&";","")&IF(ISTEXT(W3),W3&";","") &IF(ISTEXT(X3),X3&";","")&IF(ISTEXT(Y3),Y3&";","") &IF(ISTEXT(Z32),Z3&";","")&IF(ISTEXT(AA3),AA3&";", "")&IF(ISTEXT(AB3),AB3&";","")&IF(ISTEXT(AC3),AC3, "") Thank you! -- Thank you, scrowley(AT)littleonline.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF-ISTEXT formula | Excel Discussion (Misc queries) | |||
| ISTEXT TRUE then copy formula from cell X | Excel Worksheet Functions | |||
| Concatenate question | Excel Worksheet Functions | |||
| ISTEXT | Excel Discussion (Misc queries) | |||
| I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) | |||
Threaded Mode
