| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting data
I am trying to work out how to extract a number (variable length) from list of cells and move the number to a new cell (cut it) hope below mak some sense - from - no type 25 people online 1 purchased 120 total on line today 1233 total on line year to - no------type 25------people online 1-------purchased 120-----total on line today 1233----total on line year '----' for display purposes only - padding any help, would be gratefully received Steve -- mac_fixe ----------------------------------------------------------------------- mac_fixer's Profile: http://www.excelforum.com/member.php...fo&userid=3013 View this thread: http://www.excelforum.com/showthread.php?threadid=49821 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
extracting data
no------type
25 ------people online 1 -------purchased 120 -----total on line today 1233 ----total on line year =LEFT(A1,SEARCH(" ",A1)-1) =MID(A1,SEARCH(" ",A1)+1,255) Regards, Stefi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting data from one sheet based on data in another - VLookup? | Excel Worksheet Functions | |||
| Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
| Extracting Data | Excel Discussion (Misc queries) | |||
| extracting data | Excel Discussion (Misc queries) | |||
| extracting data | Excel Worksheet Functions | |||
Linear Mode
