| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text join formulas working but act as straight text when modified
I have a spreadsheet in which I am using left and right functions to populate
a new column. This seems to work if I key the whole thing in at once. When I try to modify the formula, it stops working and displays as straight text. Format of all cells is general. The formula in question is as follows: =LEFT(B5,2)&RIGHT(B5,2)&(A5). It works after I key it, but if I key any change to it, it displays as text only and stops working. Thanks for the help! Ken K. -- akkrug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| join text | Excel Discussion (Misc queries) | |||
| How do I join text from 2 cells, and make them appear in 2 lines | Excel Discussion (Misc queries) | |||
| Straight Text Displays as a series of ####### | Excel Discussion (Misc queries) | |||
| Join text | Excel Discussion (Misc queries) | |||
| Delete Spaces and Join Text in Cell | Excel Worksheet Functions | |||
Threaded Mode
