Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing Data with
I am in the middle of collecting data from one database so we can dump
it into another database. For various reasons the information is coming over to me in some predefined formats within excel. I was wondering if there is a way that I can parse data out within the same column and put it in another column. Example: Old Data Format within 1 column: *A4GNNV04 - 04 ANDREW LN GAMAY NOIR NV LC-43 168.00 RK-47D 20.00 RK-55C 6.75 Desired Format within 3 columns: *A4GNNV04 - 04 ANDREW LN GAMAY NOIR NV LC-43 168.000 RK-47D 20.00 RK-55C 6.75 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Parsing Data all in one cell that is seprated by the Enter key | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
The SEARCH function and parsing data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |