Excel Help

Forum guidelines BT super discount
Other Resources My Cup of Joe » Excel Help Rss Feed  
Moderators: k9car363, the bear, DerekL, alicefoeller Reply
2014-03-06 3:14 PM

User image

Elite
4564
200020005002525
Boise
Subject: Excel Help
So our programs kick out weird strings of numbers. I am wondering if anyone can help me figure out how to paste this string in a certain manner.

For example, here is a value I paste

4 10-18-13 13-4953 O 021635 00 N 05 206902.46 99 H

I want to be able to paste it and have each of them paste into their own column so I can easily copy the 9th column (206902.46) if I want to.

Is this possible?


2014-03-06 3:25 PM
in reply to: JoshR

User image

Elite
4564
200020005002525
Boise
Subject: RE: Excel Help
I found my own answer after revising my google search.

Text Import Wizard > Fixed Width
2014-03-06 3:26 PM
in reply to: JoshR

User image


71
2525
Subject: RE: Excel Help

You can use the Data-Text to Columns function to separate numbers. It looks like you might be able to use spaces to select the separations.

2014-03-06 3:31 PM
in reply to: 0

User image

Veteran
1019
1000
St. Louis
Subject: RE: Excel Help

Copy your text in to a cell.  Click "Data", then "Text to Columns".  Choose delimited, and then select space as one of your delimiters.  

ETA: That guy types faster than me. 



Edited by kevin_trapp 2014-03-06 3:33 PM
2014-03-06 9:29 PM
in reply to: kevin_trapp

User image

Pro
9391
500020002000100100100252525
Omaha, NE
Subject: RE: Excel Help

Ditto what the others said.  Text import does the exact same thing, but the "text to columns" is a little easier because it does it inline.

2014-03-06 10:19 PM
in reply to: tuwood

User image

Master
2380
2000100100100252525
Beijing
Subject: RE: Excel Help

The next response is:  If you're regularly pasting values into an Excel sheet... learn some VBA and automate your process. 

2014-03-07 8:49 AM
in reply to: moondawg14

User image

Elite
4564
200020005002525
Boise
Subject: RE: Excel Help
Originally posted by moondawg14

The next response is:  If you're regularly pasting values into an Excel sheet... learn some VBA and automate your process. 





I don't actually. We have 2 proprietary software programs. "Old school" and the newer version. Old school gives awful outputs and is a giant PIA. Thankfully I only use it once a month or so.
New Thread
Other Resources My Cup of Joe » Excel Help Rss Feed  
RELATED POSTS

Excel help

Started by KrisSeer
Views: 878 Posts: 8

2010-06-01 6:14 PM tracyhmcd

Help with Excel please

Started by CBarnes
Views: 558 Posts: 4

2010-03-07 2:58 PM CBarnes

Excel 2007 Question...NEED HELP!

Started by miami9296
Views: 777 Posts: 6

2009-11-03 4:00 PM miami9296

Need Excel Help Pages: 1 2

Started by Sharkie
Views: 1181 Posts: 31

2008-08-22 8:32 AM Sharkie

Excel help please

Started by MomX3
Views: 585 Posts: 8

2006-11-21 11:40 AM MomX3
RELATED ARTICLES
Injured Athletes: Nutrition Tips to Hasten Healing
date : January 22, 2013
author : Nancy Clark
comments : 0
What can I eat to heal quickly? How can I avoid getting fat while I'm unable to exercise? Should I be taking supplements? This article will address those concerns, plus more.
 
How to swim without being exhausted
date : August 29, 2011
author : Tri Swim Coach
comments : 0
If swim workouts are much more trying than your bike and run workouts, try these tips
The Three Most Important Concepts for Beginning Swimmers
date : May 6, 2011
author : garyhallsr
comments : 0
Being comfortable in the water and knowing where your body parts are trump power and strength any day
 
April 2007 Swimming CHAT
date : June 27, 2007
author : Tri Swim Coach
comments : 0
Questions and answers on sleeve vs sleeveless wetsuits, benefits of bilateral breathing and practicing it, technique drills, sighting practice, paddle use, weight training and flip turn help.
February 2007 Swim Training Chat with Coach Kevin Koskella
date : March 7, 2007
author : Tri Swim Coach
comments : 0
Discussions on hand entry, common triathlete training mistakes, the best swim drills, useful swim tools and flip turn help.
 
Swim Help! Gasping for Air
date : June 5, 2006
author : acbadger
comments : 8
When I swim I struggle to get a full breath and consequently run down faster. I spend part of my training on the side of the pool gasping for air.
Upcoming Triathlon on 49th Birthday - Help?
date : January 1, 2006
author : acbadger
comments : 1
I’ve signed up to do the St. Anthony’s Olympic Triathlon in April. I will be 49 in May and need some advice on a good training program to fit into my full time work schedule.
 
Help Wanted
date : September 10, 2004
author : Ron
comments : 2
Your help is needed to keep BT the best of the best.