[chanshe112]

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

[valis]

What is your question? Sorta defeats the purpose of homework to do all the work for someone else, eh?

and welcome to TSG.

[chanshe112]

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]

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]

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]

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]

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]

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]

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.