Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel 2007


(!)

chanshe112's Avatar
chanshe112 chanshe112 is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
08-Aug-2012, 10:03 AM #1
Excel 2007
Hello Guys,

I am a new user, I have a notepad with all the data I want to paste this data in excel with the correct information required in the particular cell. Please guys help I am suppose to submit by Friday.

Regards,
chanshe112
Attached Files
File Type: xlsx Title work book.xlsx (58.2 KB, 154 views)
File Type: txt sample 1.txt (1.1 KB, 16 views)

Last edited by chanshe112; 09-Aug-2012 at 07:36 AM..
valis's Avatar
Moderator with 63,341 posts.
 
Join Date: Sep 2004
Location: as above
08-Aug-2012, 10:51 AM #2
What is your question? Sorta defeats the purpose of homework to do all the work for someone else, eh?

and welcome to TSG.
chanshe112's Avatar
chanshe112 chanshe112 is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
08-Aug-2012, 10:57 AM #3
Excel 2007
Hello

My question is there a formula or any kind of function which I can use to do this work. I want 4 characters in the first column which is sr. no, 4 in title, 8 in first name, 2 in middle name, 15 in last name, 19 in company job title, not more than 15 in address so on and so forth.

Regards,
Shekar
valis's Avatar
Moderator with 63,341 posts.
 
Join Date: Sep 2004
Location: as above
08-Aug-2012, 11:00 AM #4
I'm certain that there is, but again, we generally don't assist with homework. It defeats the purpose of learning the formula. I'm assuming this is for school, correct?
chanshe112's Avatar
chanshe112 chanshe112 is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
08-Aug-2012, 11:04 AM #5
No Vilas this is just a sample of the work load which I am going to get it in my office I want to learn the formula. If you can please help me.
WendyM's Avatar
Trusted Advisor with 3,995 posts.
 
Join Date: Jun 2003
Location: Northern California
08-Aug-2012, 11:10 AM #6
If this is actual data, you've just posted a ton of people's personal information on this website, which I doubt they'd appreciate. You should probably delete that txt file from your post.
chanshe112's Avatar
chanshe112 chanshe112 is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
08-Aug-2012, 11:12 AM #7
These are fake database, wendy, I am sure that they will not mind. But still I will take your suggestion and delete it once I get a solution for it.
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
 
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
08-Aug-2012, 11:12 AM #8
This is going to sound really strange, but i think it will do the job.

When i open the txt file, it opens in notepad.
Ctrl+A (to select all) and copy (Ctrl+C)
Open Wordpad (in accessories folder)
paste into wordpad (Ctrl+V)
copy from Wordpad (Ctrl+A, Ctrl+C)
open Word
paste into Word (Ctrl+V)
Find & Replace (Ctrl+H)

tricky part here is adding the tab characters
click on the 'More...' button and click Special - select tab character.
Select and Copy this character (Ctrl+C)
In FIND put 2 spaces
In replace, paste the tab character (Ctrl+V)
click replace all

now to get rid of the extra tabs
in find delete anything in there and paste in 2 tab characters
(keep just the one in replace)
click replace all and continue until there are no replacements

Select all and copy
paste into excel

There may be some data with an extra space character at the start or front - will this be a problem? If so, you could try using some clean formulas =clean(A1)

Hope this is of use.
chanshe112's Avatar
chanshe112 chanshe112 is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Aug 2012
Experience: Beginner
08-Aug-2012, 11:21 AM #9
Thank you GeorgeJ, It did help me in some extent but not completely I will paste a sample of it

3001 Dr. Apolonia Joe Saskatoon.
Saskatoon. SK Canada 3063820241

now this is the data, what I want to do is, I want to assign or specify this data to a specific cell for example
Sr. no. is of 4 characters, it should accept only 4, I am able to do it with with data validation but the tricky part comes with the company job title and the address in it.

So if any one can help that would be appreciated.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑