Separating info from one cell into 2 different cells

Janecat2

New Member
Joined
Oct 30, 2006
Messages
6
Whenever I get information from finance.yahoo.com or from my job and put it into excel all the information seems to go in one cell and numerous rows. (I think its b/c I am putting information that isnt' meant to be in excel and forcing it to open up there.)

For Example in cell A1 I will have
"AIG , AMER INTL GROUP I , 66.08 , 1:16pm , 169.455B , 16.736 , 2.01 , 9.47 , 0.78"

Cell A2 I will have
GOOG , GOOGLE , 508.9 , 1:21pm , 158.845B , 22.361 , 17.511 , 26.29 , 1

What I want to see is cell A1 as AIG and cell B1 as 66.08 and cell A2 - GOOG and cell B2 508.9. I don't even want the rest of the stuff.

Is there any way or formula I can use to just pull the information out of cell and have it separated for me?
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Hi,

Try using Data...Text To Columns with the comma as the delimiter.

Dom
 

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
874
Select the column and then use /Data/Text to Columns based on a delimiter of "," . This will get your data into columns and then you can delete he columns you don't want.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,916
Office Version
  1. 365
Platform
  1. Windows
If you highlight the column, and use Text to Columns (found under the Data menu), you can parse the data into multiple columns by selecting the Delimited Option, selecting a comma as your Delimiter, and clicking Finish.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

If you're trying to keep track of stock quotes, Excel has a tool that'll do it for you: goto Data-->Import External Data-->Import Data-->Select "MSN MoneyCentral Investor Stock Quotes" and follow the wizard. You can track as many stocks as you want.

You'll get something like this:
Book2
BCDEFGHIJKLMNOPQ
1Stock Quotes Provided by MSN Money
2Click here to visit MSN Money
3LastPrevious CloseHighLowVolumeChange% Change52 Wk High52 Wk LowMarket CapEPSP/E Ratio# Shares Out
4AIG-AMERIC.INT.GRPChartNews66.267.0566.965.91########-0.85-1.27%72.9760########6.1211########
5Google IncChartNews509.7513.26514.98508.67########-3.56-0.69%558.58375########11.7743.6########
Sheet2


(I had to tweak it a bit to get it to fit the page)...

You can then link just the information that you want on another sheet.

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,561
Members
414,077
Latest member
ammylar5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top