Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
EDIT: the formula =FIND(".",B1) should have been =VALUE(LEFT(B1,
(FIND(".",B1))-1)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parsing a text string into separate cells | Excel Worksheet Functions | |||
parsing a date field | Excel Discussion (Misc queries) | |||
Line information pulled out base on date | Excel Discussion (Misc queries) | |||
String parsing with variable lenght strings | Excel Worksheet Functions | |||
Parsing when deliminator is a string | Excel Worksheet Functions |