Forum Discussion
aaronhutchins
May 11, 2020Copper Contributor
How do I change my data column of many words to only show the first word??
I have a column of 2000+ items. Basically the column is for full name (first and last). I want to know how to adjust the column so that it only contains the first name ONLY (so the first word). Is th...
Patrick2788
May 11, 2020Silver Contributor
Consider a small example:
In this situation the entire column can be completed by pressing Ctrl+E when in B2. Flash Fill.