Replacing Multiple Spaces with Line Breaks

[ryanh6]

I need a quick fix for an issue I've been having. Basically I have a data base, and I send versions to people to populate. However, in the excel sheet that I have sent, people have been inserting multiple spaces, in place of a line break. I need to remove these spaces and replace them with a line break, without removing the spaces that belong between words. I have tried many combinations of the substitute and trim function but have not found any solution. Thanks in advance!! See below for example:

123-456-789.0 987-654-321.0 456-789-123.0

123-456-789.0 Document Number1 987-654-321.0 Document2 456-789-123.0 DocumentName 3

<tbody>
</tbody>

 

[lhartono]

Can I get the file with sample data?

 

[István Hirsch]

Or replace the spaces with another character as the editor of the page deletes surplus pages so they are not visible.

 

[ryanh6]

Or replace the spaces with another character as the editor of the page deletes surplus pages so they are not visible.

Each cell would be in this format, with 700 cells in this format, except spaces instead of "-"

Thanks!

123-456-789.0 Document Name 1-----------------------------------------987-654-321.0 Document Name2-----------------------------------------456-789-123.0 DocumentName 3

<tbody>
</tbody>

 

[shg]

Find and replace:

In the Find what, type space space

In Replace, Ctrl+J

Replace all until there are no replacements

Then replace Ctrl+J Ctrl+J with Ctrl+J until there are no replacements

Takes longer to describe than do.