intercameleon
New Member
- Joined
- Feb 18, 2011
- Messages
- 3
Hello,
I am having difficulty with the following problem:
I have in column A 150 rows of text containing between 4 and 80 words (20 to 300 characters or so) and I need to insert /n every 80 characters without cutting words.
For example:
Cell A1
Hello my name is peter. I am married and have three kids. I work as a postman and enjoy meeting new people.
this should become something like:
Hello my name is peter. I am married and have three kids. I work /n as a postman and enjoy meeting new people.
The use of a simple text-to-column would permit me to reconstruct (using =A1&" "&B1...) the phrase and insert /n every X words but wouldn't take into consideration the number of characters (which is a problem).
If anyone knows a macro or formula that could help, I would much appreciate it.
Thanks,
Mike
I am having difficulty with the following problem:
I have in column A 150 rows of text containing between 4 and 80 words (20 to 300 characters or so) and I need to insert /n every 80 characters without cutting words.
For example:
Cell A1
Hello my name is peter. I am married and have three kids. I work as a postman and enjoy meeting new people.
this should become something like:
Hello my name is peter. I am married and have three kids. I work /n as a postman and enjoy meeting new people.
The use of a simple text-to-column would permit me to reconstruct (using =A1&" "&B1...) the phrase and insert /n every X words but wouldn't take into consideration the number of characters (which is a problem).
If anyone knows a macro or formula that could help, I would much appreciate it.
Thanks,
Mike