thirsty4knowledge
asked on
Wrap long column to next row
Afternoon Everyone,
Looking to take the last cell of each row and wrap it to the next row if its long. Only the last column needs to be wrapped to the next/ multiple rows.
Would like it to look like:
[B]name location1 location2 various dat [/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89
859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat [/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89
859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat [/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89
859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
Currently looks like:
[B]name location1 location2 various dat[/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89 859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat[/B] 88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89 859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat[/B] 88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89 859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
Looking to take the last cell of each row and wrap it to the next row if its long. Only the last column needs to be wrapped to the next/ multiple rows.
Would like it to look like:
[B]name location1 location2 various dat [/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89
859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat [/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89
859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat [/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89
859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
Currently looks like:
[B]name location1 location2 various dat[/B]88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89 859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat[/B] 88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89 859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
[B]name location1 location2 various dat[/B] 88 868 80 81 82 83 84 85 866 8 860 86 865 864 863 861 89 859 858 85 856 855 854 8660 862 892 8641 86 8613 853 8664
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It's not. Just highlight the cells you want to format and then go through the same steps.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER