I have topics in column A and what to create a friendly URL of the most important words of those topics in column B (so NOT the entire topic name).
I started to manually fill this out, like so:
Now after completing a few values in column B already, I was typing in column B4 and started typing "warm" and all of a sudden cell B4 got a suggested text "warm-weather-wedding", which was exactly what I needed. Not only that, but also the rest of column B (from B5 downwards wherever I have a value in column A) was prepopulated with similar text suggestions...also an Excel hint appeared. It seemed as if Excel knew I was trying to get the most important words from column A, and suggested text for that to enter in column B. I did not accept those suggestions (I believe I pressed Escape), but afterwards thought it was exactly what I needed. I now cannot reproduce that behavior anymore...is anyone familiar with this feature in Excel and how can I trigger it again?![]()
Please Login or Register to view this content.
Bookmarks