| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text, like "Text to columns", but as a formula
You are right. 50 is an arbitrary number of characters, but the number has to be big enough to accommodate the longest names that you might have to parse. It doesn't really matter how big the number is because the "=TRIM" function eliminates all the blank spaces beyond the end of the name. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=539165 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Being treated as Text | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
