Split one cell to two cells

[raje]

Hi ...
i want one cell data to two cell splitting With Removal of "x" symbol. and column N should be formed. looking for help.

Thank you...

[leelnich]

Hi raje, welcome to the forum! Paste this in N2 and copy down:

Please Login or Register  to view this content.

If you're not sure how far down your values extend, wrap it in an IFERROR function and show blanks if column D is empty.

Please Login or Register  to view this content.

[raje]

Hi leelnich, Thank you for inviting.
i have many rows and i want to go another step of sorting my data. i need split those columns by two columns mandatory. how to make as macro plz?

Thank you!!

[jeffreybrown]

Give this a test on a copy of your workbook. Does this do what you desire?

Please Login or Register  to view this content.

[raje]

helo jeffreybrown ... good..thank you.

how to minimize those rows to as my sample file. please reduce my rows by sorting.

Thank you....

[jolivanes]

Please Login or Register  to view this content.

Don't need to add and split columns.

[raje]

hi ... i have tested post#5 sample file. but showing debug error. or #1 sample file also not working.

Thankyou...

Best wishes.

[jolivanes]

Don't know who or what you are referring to but the code in Post #6 works in the attachment in Post #1

[raje]

Don't know who or what you are referring to but the code in Post #6 works in the attachment in Post #1

Hi sorry. i am new to this site and confused. yeah your code is working. and i need #5 sorting. please have a look.

[jolivanes]

Like this? Remember, this refers to the attachment in Post #1.

Please Login or Register  to view this content.

[raje]

Like this? Remember, this refers to the attachment in Post #1.

hi tested with #1, but not sorted like C1, C2 etc repeats many times. need single time only. like unique. see sample format

Thank you.

[jolivanes]

Re: but not sorted like C1, C2 etc repeats many times
Don't know what that means.
In my example, the results go in Column N and that is the Column that is sorted.
After you tried my code on the attachment from Post #1 and checked the result, let us know what needs changing.

[jolivanes]

You marked it solved but according to your last post (Post #11), it is not!
How did you fix it? It is nice for someone that has the same problem to see the final result.

[raje]

yes, solved up to #4, from #5 not solved and making new post for that. that is rows sorting.
Thank you..