Grabbing Text From a Cell

[dandoescode]

I have a poorly formatted spreadsheet which I need to update. The first user placed the entity name and description within the same cell, is some way to tell VBA to go into the cell look for any information after a return and cut the information after a return or something like that?

Capture.PNG

[stnkynts]

Maybe it is just me but I am not able to see your picture.

Note: Pictures are not as helpful as submitting an actual workbook.

[dandoescode]

That's odd its displaying fine on my end. Sorry about that.

[dandoescode]

Sample rows, hopefully this works out a little better than the picture. In particular I'd like to be able to take column B, and make it into separate columns for name and description, I don't know of a way to do this without an existing comma or semicolon within excel. I'm hoping there is some neat VBA way to do it or its gonna be a lot of cut and paste work.

[stnkynts]

What does "cut the information after a return" mean to you?
What does "or something like that?" mean to you?

In your example workbook, demonstrate what you want the final product to look like.

[jindon]

Is this what you after?

Please Login or Register  to view this content.

[dandoescode]

Jindon YOU ARE THE MAN! That is exactly what I was trying to do.

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.