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

What's a realistic level to enter a FAANG or other tech SaaS company at with 6 YOE. CPA from Big4 then strategy consulting at same Big4. 1 year S&O experience at tech PE.

Manager, SM? Senior associate? Director? L3-?

Expected comp?

like

Hi fishes,
I have 2 years agreement for 2lakh if one leaves before completing 2 years. What if a person put papers after completing 1.5 years and then serve three months np . Will he have to give 50k ?? As amount is decreased with Time.
<1 year then 2 lakh
>1 <1.5 years 1lakh
1.5 to 2 years 50k

like

Hi all, my joining in LTI is on October 1st

I am currently in my hometown in punjab

Can somebody help me if i need to go to Bangalore and collect my laptop on the day or joining or can it be shipped to my hometown.

Also since Noida/Delhi is closer to my location,can I go to ncr and collect laptop from there.

P.S. - Bangalore is my base location as per offer letter

like

What is the avg hourly wage for a medical assistant in western Tennessee?

like

Are we eligible to use Clear if we are neither green card holders nor US citizens?

Got an opportunity in Oman under a renowned consultancy firm for OMR 650 (inclusive of allowances)....individual person...is that a decent salary?

like

What are everyone's thoughts on the new MacBook Pro? Anyone order one yet? If so how did you configure it?

like

Have a final round at Slalom for Solution Architect role in Chicago within their tech enablement practice (focused primarily on custom software dev). Any idea on expected base, bonus, etc?

likefunny

Looking for some GMAT score improvement success stories. What were your study habits? What resources did you find to be the most insightful? Did you take a class or study on your own? I am about to put together a study plan, but I want to see what other individuals found to be the most invaluable during their time studying. TIA!

like

Hi All,
I've received a draft OL from Jio and was told I'll be receiving the Official OL in 3 to 4 days. Is there a possibility the company would reject the offer as I haven't received it yet and when spoke with hr, was told it is still pending for approval.

like

Worth it to use 300K bonvoy points for over a week in Maui? I keep hoarding these things but trying to plan a Hawaii trip and think now is the time to burn them

like

Thoughts on living in close proximity to oil wells in Brea (e.g. seems like Brea Olinda school district is sitting on several active oil wells)? Like the neighborhood but concerned about health

like

Where can I find some freelance HTML5 developers?

like

I know this gets asked a lot but what are some things I should do before quitting? I already downloaded my cpe reports but anything else? Thanks

like

What advice would you give a new experienced hire to succeed from day 1 at the manager level? Looking for structured items to help coach a mentee

like

Best way to spend Hilton points ? got about 500k points but cannot travel this year?

like

Fun things to do in Rhode Island? Have already been to Providence!

like

Someone hit me with that HMBradley referral, my inflation hurts

funny

Currently focused on "Visual Analytics", but what is the best way to keep career trajectory moving upwards? Currently making $120k. Is there more room to grow in the Business Intelligence/Power BI/Tableau space? What sort of role would you consider a "ceiling" for an exit opp as a BI consultant? Anything where you can make $200k+?

Should I consider trying to make a change? I'd like to grow beyond dashboard building and start playing a more strategic role. Maybe move into product roles?

like

Additional Posts in Excel Genius

Does anyone know if Excel is compatable with Adobe Sign/PDF? I'm trying to automate data entry from Adobe sign/PDF to an Excel sheet. Adobe

like

Can anybody tell me how one can open a list off all tabs to navigate in a workbook with many tabs?

like

I’m using a pivot table to show how different initiatives fall under broader themes. If I’m screen sharing the pivot table w my audience and we make a live edit to one of the initiatives on the table itself, is there a way this can also change the initiative in the source data?

like

Pivot keeps changing my dates from m/d/y to D-month. Whyyyy

like

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

Advice needed: I have a manager that I do PM work for, including metrics, and often get asked to “re-run the numbers” but this is an incredibly complex process that takes a lot of time to make accurate in excel, even though it’s a single-figure output on a team/teams progress

Is there any way to make them realize the effort that goes into it on my side? I’ve stated before but they mostly brushed it off - worried I backed myself into a corner by not making it sound hard enough the first time

like

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Anyone know how to delete multiple custom cell styles at once without running a macro?

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

like

Does xlookup take more processing power than index match or is it negligible?

like

Hi all!
I have a file that is full of hyperlinks to different files in another folder.
I moved the location of tbe original fil and hyperlinks stopped working.
Now I also want to move the location of the hyperlinks folder.
Is there a way of fixing the links? (File names are still the same)

like

Anyone know a quick way to value paste for each tab to another excel file if I have 40 tabs in a file needed to copy. Each tab has many formula in there, but when copy-over I only want them to show hard-coded numbers rather than showing all formulas.

like

does anyone know what CVS medical excel assessment for finance analyst consist of? I have an interview in a few hours

like

Any one good with Tableau I have a question

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Anyone kind enough to help me start a PE fund model with a waterfall.
Struggling to get started.

like

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have returned some hard to follow, bad results that miss the mark.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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