Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Search/Find and Move Text to a New Row Macro Excel


  • Please log in to reply

#1
MsNovi

MsNovi

    New Member

  • Member
  • Pip
  • 1 posts
I need help with a rather complex macro and would appreciate anything I can get.
I have a spreadsheet containing a lot of text. Whenever there is a “~” character, need to remove the ~ and in effect do a line feed. For example if I have some text like so:

This is sample text. ~ This is some more text.
Here is even more text that would be in other cells.

I need it to be modified like so:

This is sample text.
This is some more text.
Here is even more text that would be in other cells.

Breaking it down this means I have to be able to find the ~ character, create a new row, delete the ~, and then copy everything after the ~ into the new row.

I have tried many different things with varying degrees of success, but none of my efforts can do exactly what is needed. I can get new rows inserted, but then it will sometimes stop at the first ~ it finds. Other times I was able to do multiple lines, but not multiple cells in the same row containing ~. I could never figure out how to copy the remaining cells down to the next row.

Thanks in advance for any help you can provide.
  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP