{ "media_type": "text", "post_content": "Looking to get rid of ALT+ENTER in cells, it’s messing up my import file formatting when I convert the file to .txt.\n\nCould some recommend a way to do this quickly, I’ve tried find and replace control j, and that worked on most but not all cells.", "post_id": "603f98c3b6d5d6001c68c3d5", "reply_count": 1, "vote_count": 2, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }

Looking to get rid of ALT+ENTER in cells, it’s messing up my import file formatting when I convert the file to .txt.

Could some recommend a way to do this quickly, I’ve tried find and replace control j, and that worked on most but not all cells.

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

You can do find and replace and open up the options menu and check to include carriage returns. So the find field is blank but the carriage return option checked

likehelpful

Related Posts

I know we all love to shit on Air India or PIA but a travel crisis like this shows you how important it is to have a national carrier. You control the country’s travel destiny not some Arab Carrier.

like

Delta Gold Amex vs Alaska cards

Anyone have pros or cons of either? Found an offer for Alaska that has 60k + $100 statement credit + companion pass annually after $3k spend in 3 months. Delta Gold offer is as stated in their site. Preference would go to whichever one offers an instant card number to use, but I believe both of them do that.

Edit: am in SF with plans to take trips across US as well as up and down west coast

like

Best delta platinum gift?

like

Travel recos for Nice, France?? ✈️

Been friends w/ a girl for years since I met her overseas (chatting on phone often). When we started travelling together on a few trips, she annoyed me on so many levels, we are just not compatible so I no longer want to travel with her. I still value our friendship and don't mind continuing catching up on the phone. I'm non-confrontational so instead telling her i find her difficult/annoying, I just stopped inviting her/avoid trips/added a lil more distance. But she doesn't get it..-contd

like

Can I transfer United miles to Chase Reserve for Points?

Do we still be needing a NIE letter if we travel back to the US from Dubai, in January next year?

like

Favorite Marriott hotel in Vegas? Never been, love some recommendations!

This may have been asked before, but will really appreciate it if anyone could send me the link to where Marriott/Hilton etc sell their respective brand mattresses

like

I worked for Kaiser Permanente and now United Health Group. I need some likes so I can ask questions. Shoot me a message if you have any as well.

likesmarthelpful

I’m quitting my job and taking a remote roll so that I can travel and be happy.

like

Will SPG Green Choice award of 500 points also triple to 1,500/night under the consolidated reward system? Couldn’t find anything in the Marriott marketing materials

like

Best SPG/Marriott in Napa?

like

Need genuine advise. Got a call from Oasis Resource management pvt ltd. They said that they can help in conducting interviews in canada or UK. Total 5 interviews. They will charge 72k for this and 2k for profile investigation. They claim that under work permit, accomodation, travel cost, meal will be borne by employer for whole work visa tenure along with salary as per profile and market standard.
Are they legit ?
Should i proceed with them ?
Any chance of them being fraud ?
I m ca 7+ yoe 32ctc.

like

Any recommendations on Bangkok Spg or Marriott?

like

Hi All, I am a seasoned South Florida PR freelancer currently seeking remote opportunities in-house or at an agency. My experience includes Travel, Food & Beverage, Spirits and Consumer. I'd greatly appreciate any leads or feedback, thank you!

like

Does PWC and Deloitte have dedicated application security pen-testing team? How much percentage of the time you guys travel? Do you work from home or based out of any particular location?

like

Any other travelers feeling the pain of Lifetime Fitness discontinuing their hotel passes at the corporate level?! What was $10/day hotel pass is now overnight a $40 general day pass!

Also, has anyone had success in working through their firm to negotiate a deal?

like

wait for the x3 SPG/Marriott conversion or do the united points + 7 days Marriott package before aug 1st?

like

SO wants to go to the Maldives but I’m unsure how to get there making the best use of my points (United and Delta) any advice?

like

Additional Posts in Excel Genius

have anyone got second offer from TCS after not joining through first offer?

like

Looking for Deloitte referral. Looking to get into consulting from audit Deloitte

like

Best steak in Boston/Camberville?

like

I️ was working on proposal coordination for a non profit before and then I got an offer to work in Tech. I️ miss proposals tbh but every time I️ interview for a proposal coordination role for a gov contract I️ blow it because the proposals are different from what I️ worked on in the past. Any advice on how to get past this so they give me a chance to learn?

like

Anyone else getting tired of Burger Kjng's schtick?

Every now and then one of their madcap efforts is entertaining, but mostly they're just irritating and seem desperate. Like this one.

Post Photo
likefunny

Looking to get into software development/coding. What are the pros and cons of working for an agency vs in house at a firm vs working for a software company.

like

I'll be an incoming associate in FDD this summer and just curious what does a day to day look like for someone that entered right out of college? I'm assuming it'll be a lot of excel but I feel like everything I see on here is geared towards seniors and up or people that transferred in. Any advice?

like

Is McLean a nice area to purchase a condo? Looking to rent it out in the future. Found some solid ones for 400k.

like

EY-Parthenon EYP SDs, this bowl is new and started to foster community within SDs, discussion and a place to constructively vent when needed. Approval required to join to avoid lurking and encourage discussion. It’s early goings, so don’t be shy…

like

Can I show LTI counter offer to Mindtree ? Or vice versa ? Mindtree Larsen & Toubro Infotech

like

How to feel popular while on social lockdown...

Post Photo
likefunnyuplifting

What does role - director of product management at Dell do? Is it possible to exit as a new M?

like
like

Hi fishes,

I am joining an insurance company as a business analyst

YOE - 2 YRS

Was in a small company and got a healthy jump for this one.

Would like you folk to guide me on this-
Should I be restricted to the insurance sector or should I try to push my horizon for the next jump. What are the things/ technologies/ tools o should learn along the job after I enter into this role.

likehelpful

If you get laid off as green card holder, do you have to go back to your home country? Can I take contract jobs while searching for full time?

like

What is the CTC of Marketing Specialist In Gartner with 2 Years Of Experience and what is the percentage of Annual Hike given ?

like

I'm not ready for Monday

Post Photo
likefunny

Hi. I'll be joining pwc sdc in next week. By when can I expect by onboarding mail. And also by when can I expect my laptop. And also can someone throw insights on the onboarding process. It will be very helpful. TIA

like

BCGer numero three!

like

Additional Posts (overall)

How can I goal seek tariff (price per unit) to meet a certain Equity IRR based on a target Hurdle Rate using VBA? Can anybody please share a code or explain it to me like I'm a 12 year old. 🙏🙏

like

How do I return values found in Array 1 unless they are found in Array 2? I don’t want to remove duplicate values, I want to remove values ENTIRELY that have duplicates. Thanks!

like

What task would you expect excel of being able to do but you have never been able to make excel do it.

like

I have a master data list on sheet 1. Need to split the data by location (4 locations) on other sheets but only want to update sheet 1 as I get more data. How can I make it so?

like

What’s the best resource to learn how to do a complete DCF valuation?

like

Is there an easy way to create flow chats and diagrams in Excel without the Visio add-in?

like

Trying to figure out how to understand the variability of price data along a downward trend. Any ideas? If the data wasn’t trending, I’d just evaluate the distribution of data, maybe normalize it.

Happy Friday Eve

Post Photo
likefunny

I recently switched my jobs and I am doing a lot of analysis in excel using big data given to me. Are there any courses or any videos I can watch to enhance my analytical skills using excel?

like

Also posted in data analytics bowl, but quick question. I am looking to use Tables 1 and Tables 2 in this screenshot to yield the “ideal outcome” table in Power BI (using query editor). The tables I have setup look similar to Table 1 and Table 2 (it’s a mapping activity of controls to various categories). Is anyone familiar with the proper steps / video that will help me arrive at the ideal outcome?

Post Photo
like

Hello Excel Geniuses- I need help. I have never learned macros but I’m about to but before I invest the few hours or however long it might take, I wanted to find out if it is possible to do what...

likehelpfulfunny

I am looking for a structured excel course with case studies. I don’t use excel much in my current job, and I need to prepare myself for interviews with excel exam components. On my own, I wouldn’t know what type of tasks I should practice. Thanks for any help!

likehelpful

I have about 10 variables each with a certain score (10,14,15, 20,20,20,7,9,2,1). I need the max value is there is a single winner (MAX function work here.) If there is a tie for the highest score, I need an output that says “Multiple.” How would I go about this?

Thanks in advance!

like

Silly question - what’s the difference between the 0 and FALSE in the following VLOOKUP(value,table,column reference,0) and VLOOKUP(value,table,column reference,FALSE)

like

I’m trying to work smart & not hard- started recently and what’s some of excel features you recommend I need to get in habit of (short cuts etc...) help.

likefunny

Trying to use power query but it can’t find a connection in excel, saying the external component has thrown an exception. Any ideas?

Hey everyone, I'm looking to get some help tracking product sales for my business. I have an excel sheet, but it still needs some work. Can anyone help?

Thanks

like

I'm planning to learn power pivot and power querry by myself, which one should I pick to start?

like

How many people are keyboard only users? Also, how did you learn to do that and how long did it take to learn?

like

@ work we usually use shortcuts on drop down menus like pressing “Y” if a Yes option has been set onto the drop down options. This morning pressing “Y” or “N” to jump to the option doesn’t work. Is anyone else facing the same? It often saves time. Is because of a Microsoft update?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal