We need to upload an Excel file and we want to make sure there are no characters outside of A-Y and 2-3425
I recall doing this before, but forgot. I know to highlight all the text we want to keep or upload... then... ???
We need to upload an Excel file and we want to make sure there are no characters outside of A-Y and 2-3425
I recall doing this before, but forgot. I know to highlight all the text we want to keep or upload... then... ???
Hi try Shift + f8 to get the contiguous Cells.
Remember you are unique, like everyone else
I'm highligting all my text and clicking shift + F8 and nothing is happening
Yes, that was to ensure you only selected the Cells you selected A-Y and 2-3425.
So now what do you do to Upload this selection?
Where/How are you uploading it?
I don't want to upload it now. I want to execute it to see if there are any characters outside of my data. How?
OK, that's an unusual question but if you want to see what, if any, data is in columns 'Z' and onwards eg: 'AA', 'AB', 'AC' etc, you could apply a filter on the top row & see if any values exist.
Can you explain why there might be values beyond this Column?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks