| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help I need to extract information from¦¦¦..
Thanks - That works
Kelly "Gary''s Student" wrote: If your data matches your example, then without VBA: In B1 enter: =LEFT(A1,4) and in C1 enter: =MID(A1,8,255) The VBA approach should do the same thing -- Gary''s Student - gsnu200769 "Kelly" wrote: I am downloading information from Primavera software into Excel. My problem is that I need to be able to extract part of the information in (1) column and have it become (2) columns. Example: 4040 , Excavation Cut and Fill What I need to have is the 4040 in one column and the Excavation Cut and Fill in another field. There are approximately 250 line items when downloaded with several columns. I feel sure there's a way to do this. Can you please help and tell me how. Thanks !!! Kelly Burgess |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract workbook information | Excel Discussion (Misc queries) | |||
| how to extract information from one table to another one | Excel Discussion (Misc queries) | |||
| Extract Information to another worksheet | Excel Worksheet Functions | |||
| Extract information from the list | Excel Worksheet Functions | |||
| Please help: Extract some information from a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
