Conversation Starter
Related Posts
Conversation Starter
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
Sign Up to see all discussions
- Discover what it’s like to work at companies from real professionals
- Get candid advice from people in your field in a safe space
- Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.
"" is an unusual email domain. If correct, please proceed to the next step
Messaging rates may apply
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
New to Fishbowl?
Download the Fishbowl app to unlock all discussions on Fishbowl.
Share
Embed this post
Copy and paste embed code on your site
Preview
Download the
Fishbowl app
Scan your QR code to download
Fishbowl app on your mobile
Sign up for free to view this conversation on Fishbowl
Sign up for free to continue using Fishbowl
Messaging rates may apply
Merging two columns is a standard function that everyone should know as it is used all the time especially in admin. Tips on this shortcut are easily accessible and plentiful through a Google search. I hope you have now learned this function and add it to your spreadsheet skillset.
Conversation Starter
I tried to Merge the two columns into one by clicking the "Columns" tab in Word, but the assessment told me it was wrong. The assessment wanted me to demonstrate how to do it. I tried Google as well and tried it step by step--and it was still wrong. I tried!!
Conversation Starter
I tried to Merge the two columns into one by clicking the "Columns" tab in Word, but the assessment told me it was wrong. I tried Google as well and tried it step by step--and it was still wrong. I tried!!
Not sure what admin jobs you've been exposed to, but there are tons of times in my career that info from two columns has had to be put into one column (or vice versa). In Excel, it's the concatenate function. You mentioned Word, so you couldn't do that. But infonin a Word table can be easily pasted into an Excel sheet, then the concatenate function is run, and then you can take the combined info in one column and paste it as a table in Word. I've done that kind of thing many a time in my career. Nowadays, I don't even bother if it's non-confidential data; in that case, I copy-paste it into Perplexity or ChatGPT or Gemini and tell it to do the desired edit and then I take the revised table and paste it into my document or Excel sheet. It's a good trick to know and will come in handy in an office job.
Conversation Starter
Copying and pasting the info from Word into a table or Excel was not an option on the assessment. When I tried to copy the 2nd paragraph column of the prompt under the 1st paragraph column, it told me it was incorrect. I asked chatgpt and it still said it was wrong--so I must have missed something. Oh well!!🫠