Good morning all,
My Excel is a French version and certain functions have to be "translated" but I can do that.
I have a (very, very large) list of words in Col A
I want to put the number of letters in each word in Column B < =NBCAR(A1) > Note: NBCAR is the French equivalent to LEN
In Col C if the number of letters of the word in Col A exceeds 15 the cell is left blank, if not the word from Col A is repeated there.
I have tried but cannot get it to work. I would appreciate any help.
Henry
Maybe:
=IF(B1>15,"",A1)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Re: Word lenghts and more. Need help!
That worked with a small error - ; -Originally Posted by Domski
=IF(B1>15;"";A1)
Thank you very much.
Henry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks