#1   Report Post  
Old June 27th 06, 06:21 PM posted to microsoft.public.excel.misc
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.


Old Data Format within 1 column:

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

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 03:12 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01: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 12:34 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017