Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like
Posting as :
works at
You are currently posting as works at

Yep. Find and replace your semicolons with a carriage return/new line character

like

Thanks so much! I tried using find-replace and tried putting the replace value as alt-enter, [alt-enter], (alt-enter) , and alt+ enter variants, but none of these work. How'd you recommend applying alt-enter to a whole column?

Paste data in Notepad++ and copy-paste from there to excel

I would concatenate and do a hard enter (alt + enter)

Alt + Enter is what you’re looking for

In google sheets' find & replace, you can copy a line break character to your clipboard and paste that in to the replace field.

You can type one in a cell with the alt+enter and copy that, or copy any old line break that's lying around, like the one after the sentence above!

Related Posts

Hi everyone,

I'm having pre-joining session scheduled today. Please let me know the agenda of this session.

like

How do people here reduce their tax bills? Me and my SO earn about 400k gross and take standard deduction. We don’t own real estate, only S&P500.

like

I was accosted last night at the bar when some guy overheard me telling my date I worked at Apple. Lots of expletives and "go back to where you're from" rhetoric. Do people really feel this way? So far, everyone I've met has been so welcoming.

likehelpfulfunny

Anyone up for chat😔😔 Feeling low...

like

Got an offer, made a counter, they came back and said they’re keeping their offer where it is.

Jobs ok. Could use the benefits. Offer was below market.

Thoughts?

like

Is the pace and WLB a lot different between T1 and T2 firms in the middle east?

likefunny

Silly question but, how did you make close friends when you first moved to Miami? Feeling like a fish out of water, from Texas.

likehelpful

Very Important !!!
Anyone working in
Comcast, kindly let me know how Bonus pay works here
If they commited 1.5 as yearly bonus and if we join at Aug month how much it will be paid...
Do you get fully or its calculated based on the calendar days
Comcast

like

Confused why Wachtell qualifies as BigLaw when they have one (small) office

like

Ladies who love food: let’s try out different cool restaurants together!

likefunny

I started working for a bank and am going through the background check. They found an arrest which was dismissed and the file was sealed a few days after the check. They’re requesting the police report on top of the court order to seal. The police report is BAD. During the arrest (DUI) they wrote the report to make me seem like a complete lunatic. Embellished on several elements of the case. I am worried that giving them this report will cause me to be let go.

like

Heard somewhere the new post-MBA base comp is $180k . Can anyone confirm ?

like

Hi
Can any one refer me for .net developer
having yoe-2yrs

like

Any thoughts around how to use M&A tax skills for the better good? I’m a CPA and originally got into this for a stable / interesting job, but in the long-term I’d like to do something that either influences drafting of tax legislation or helps the public (however naive that may sound). Perhaps I’ve gotten too introspective during the pandemic. Don’t really want to go back for a JD and aside from keeping a roof over my head I’m not very motivated by money. Anyone else have similar ideas?

like

Anyone commuting from Midtown Toronto to Mississauga for work and willing to carpool??

Sometimes when work is stressful, a few minutes with a snuggling cat really turns my day around ❤️

Post Photo
like

Would like to add scarves to my wardrobe, any recommendations for a male 🐟 ?

like

Have an upcoming FB loop interview next week. And today i got reached out for another role that i applied at FB, should i bring this out to the hiring manager during the loop? Wondering if this would make any difference perhaps speeding up the decision process. Any thoughts?

like

Biggest pet peeve:
When people working at Big 4 don't understand the basics of health data privacy.

like

BPO T&S Operations Associate - Can someone tell me what does T&S stands for?

like

Additional Posts in Excel Genius

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

likeupliftinghelpful

I rarely have to use formulas in Excel, so please be kind to me.

Apart from conditional formatting cells, what formula can be used to display a word whenever a cell contains a range of numbers? Contd

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Would anyone be willing to teach me vlookup?

like

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Anyone have a good source to learn sql

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

like

Any book recommendations on excel modeling for real world business applications?

like

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
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.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal