#1   Report Post  
Old June 27th 06, 06:21 PM posted to microsoft.public.excel.misc
Javier
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
Parsing Data all in one cell that is seprated by the Enter key ChuckW Excel Discussion (Misc queries) 4 February 14th 06 04:12 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
The SEARCH function and parsing data Michael Excel Worksheet Functions 2 September 19th 05 05:36 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017