Separate into columns

[krrish]

i have a data like this..i want to seperate (|)..with this symbol..given the data below..plz giv me solution..

80000045007 CGC_TERBINAFINE STAGE-III , TERBINAFINE STAGE-III AT BLOCK-B
C4031620 Disodium Hydrogen Orthophosphate 9487 KG 4745121 DIRECT
TAPIAORATORIES PVT LTD 1901 L Street, NW, Suite 700 Washington washingtondc
united states DC 20036 1-202-293-2537

EX:

80000045007| CGC_TERBINAFINE STAGE-III , TERBINAFINE STAGE-III AT BLOCK-B|
C4031620| Disodium Hydrogen Orthophosphate| 9487| KG| 4745121| DIRECT|
TAPIAORATORIES PVT LTD| 1901 L Street, NW, Suite 700| Washington| washingtondc|
united states| DC 20036| 1-202-293-2537|

[teylyn]

Hello,

can you please find the Caps Lock button on your keyboard and turn it off? Posting in ALL CAPITAL LETTERS is considered SHOUTING and not polite.

Is your source data really in a Word document? The Word file you have posted has a variable number of paragraph marks at the end of each segment.

If your source data is a flat text file, you can just open it with Excel and use the Text-to-columns dialog to separate the data into individual columns.

Please explain in more detail, and turn off the Caps Lock.

cheers,

[krrish]

hey i am sry for that..i am new person to here..really i don't know..nd i don't hav good communication also..

[teylyn]

Any input on the questions I asked above?

[krrish]

hai.. i hav original data in word only...nd it should be like this...plz go through the attachments...nd giv me solution for this...

[teylyn]

I'm confused now.

the first Word document and the second Word document have the data in different formats. Which is the correct one?

[krrish]

second one is the correct...

[teylyn]

Is each "record" always the same number of rows in the Word file? What are the delimiters for separating the fields? Looking at your first post, the delimiters are definitely not the commas.

Can you come up with a description of how to separate the data into columns? Unless you can do that, there won't be a solution, I'm afraid.

[krrish]

i have a name like this...GAYLAN J WARD in column A
i want to get 1st characters in B column like G J W..
some one plz help me...

[teylyn]

Is this a new question? If so, please start a new thread. If not, please describe how it relates to the previous posts.

[online6]

open excel on a blank workbook

click file then open and find the sheet you want to import,

select the delimeted option and put the | symbol in the "other" box

[teylyn]

online6, welcome to the forum. Are you sure your answer pertains to any of the posts above? If so, I don't see which. Also, I have asked for input from the original poster. Please refrain from posting until the OP responds.

[online6]

open excell then click file \ open (may have to change file type to all)
find the file with the data you which to import
select tab delimeted and in the other box enter "|"

[teylyn]

online6, please do not ignore a moderator's request in this forum.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

[tigertiger]

hai.. i hav original data in word only...nd it should be like this...plz go through the attachments...nd giv me solution for this...

I think , you 'd make two stages:

1st stage: Convert the data to a table with rows divided by paragraph-mart (Ms.WORD: Select data, and then Insert tab -> Table -> convert to table), and then copy that to excel

2nd stage: In excel, base on the data - divided the groups and then creat formula reaching to result

[teylyn]

@tigertiger,

can you please read all the posts in this thread, not just the first question? The example file that the OP posted in post #5 and which s/he has specified as the data to work with and the suggestion you posted do not match.

Also, I've asked the OP to clarify if her/his latest comment is related to the original question.

Please refrain from posting in this thread until krrish has responded to my request with clarification.

Thanks.