Hi!
I need the code, which does the following:
"Examine each word of a cell and if the word's length is 6 Characters or less, then left(word, 1) else (if word's length is more then 6 characters) then left(word, 2)
Apple --> A (5)
Christi Jonathan --> Ch Jo (7 and 8)
Apple Training --> A Tr (5 and 8)
https://imgur.com/onQF3KI
I could solve it, I worked on it 3 hours. I am a beginner and it was a terrible experience. But I did it.
What sad is, that my code is 10 A4 page long. https://imgur.com/a/2RWncEF
I don't know whether its a good idea to ask for a profesionnal solution or not, but let's try. (My soul wil be broken if somebody solves it in 10 lines, which is very likely
Have a nice day!
I need the code, which does the following:
"Examine each word of a cell and if the word's length is 6 Characters or less, then left(word, 1) else (if word's length is more then 6 characters) then left(word, 2)
Apple --> A (5)
Christi Jonathan --> Ch Jo (7 and 8)
Apple Training --> A Tr (5 and 8)
https://imgur.com/onQF3KI
I could solve it, I worked on it 3 hours. I am a beginner and it was a terrible experience. But I did it.
What sad is, that my code is 10 A4 page long. https://imgur.com/a/2RWncEF
I don't know whether its a good idea to ask for a profesionnal solution or not, but let's try. (My soul wil be broken if somebody solves it in 10 lines, which is very likely

Have a nice day!