| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete Formula
Cell A1 = Betty Smith Cell B1 = Smith I need a formula that will delete Smith from cell A1, using cell B1 as the reference... Column A ____ ; B ; Formula 1 Betty Smith ; Smith ; =Betty 2 Jim Jones ; Jones ; =Jim 3 Sam Stone ; Stone ; =Sam -- azazel ------------------------------------------------------------------------ azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250 View this thread: http://www.excelforum.com/showthread...hreadid=482914 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide formula | Excel Worksheet Functions | |||
| How do I delete the formula but keep the results | Excel Worksheet Functions | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
