Forum Discussion
copy data
If you turn your data into a Table (using Ctrl T) I think that should give the ability to leave blank cells and still have autocomplete work
Should work when text starts with blank, providing you also type a blank, otherwise I'd do a quick TRIM() function on the data then copy and paste values back over the orginal to get rid of those leading spaces.
Not sure what you meant by this bit sorry...
"get a series of relevant comments for a number of different rows where comments are not relevant to each row. Then put them together as one series of comments to paste into another doc. . "
thanks, your system worked, however when i went to copy into another doc it showed as a box rather than just a line of text so not ideal. but i have been talking to other staff here and am trying another system using if statement and then concatenate
thank you
- If you paste values there should be no box