cell data filter

[lgchandana]

Hello .

I'm new to here.
I want help to clear my problem.

SchenoLczyk|tffu9wd3PHAQ|

In above cell you can see tow section separated with "|" mark. I want get all of characters befor "|" to next cell


Final result mus see like this "SchenoLczyk"

I'm waiting for reply

Thanks

[Special-K]

=left(a1,find("|",a1)-1)

[lgchandana]

Wow.
I got it, Very helpful. rep ++

I want more one help
---------------------------------

From this cell

SchenoLczyk|tffu9wd3PHAQ|

I want get "tffu9wd3PHAQ|" this part from above cell.

Pls tell me formula to do this

[icestationzbra]

try:

Please Login or Register  to view this content.

[jeffreybrown]

@lgchandana,

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about a proper thread title and adjust accordingly...

[lgchandana]

Thanks for all reply.

i will follow forum rules

[lgchandana]

Hello Sir,

I want last help about this.

Following is my cell data without quote

"DollrdMrmannj|ikn83idHVO||[email protected]|IezodsuiL9sh"

You can see this will split by "|" mark, I want get this data to following cell as follows

B1=DollrdMrmannj
C1=ikn83idHVO
[email protected]
E1=IezodsuiL9sh

I think this want few formulas.
Please help to get this

Thanks

[FDibbins]

You were requested in post #5 to change your thread title. Please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertise, they might only open those threads. also, searching for ""help"" will not turn up too many results that will benefit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"

[lgchandana]

You were requested in post #5 to change your thread title. Please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertise, they might only open those threads. also, searching for ""help"" will not turn up too many results that will benefit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"

Edited Thread title.

I think now it is suitable for thread.

And I think you will give answer for this question

Thanks

[FDibbins]

assuming your data is in A1...

=MID(A1,SEARCH("|",A1,1)+1,99)

[lgchandana]

=MID(A1,SEARCH("|",A1,1)+1,99)

When I use this B1 cell data like this; "ikn83idHVO||[email protected]|IezodsuiL9sh"

But I want B1 = "DollrdMrmannj"

Hm...

[oeldere]

I don't see the text below in your text in cel B1.

Please Login or Register  to view this content.

If you need to look in the data in B1, then you have to change the cellreference from A1 in B1.

[lgchandana]

No.

I want do this.

A1=DollrdMrmannj|ikn83idHVO||[email protected]|IezodsuiL9sh

I want split above data to the following cells,

B1=DollrdMrmannj
C1=ikn83idHVO
[email protected]
E1=IezodsuiL9sh

One or few formulas.

[oeldere]

Use text to column for that.

excel 2007 => data => text to column

[lgchandana]

use text to column for that.

Excel 2007 => data => text to column

best answer

rep ++++

[oeldere]

Thanks for the reply and reps.

Glad i could help.

If your question is solved, will you mark the question as solved.

[icestationzbra]

in case you want a formula-based solution, assuming that your source string is in A1, put the following in B1 then drag-fill the formula towards right:

Please Login or Register  to view this content.