Is there a way to separate/split the data from cell to individual row/column? FYI, am not good in excel, knows basic formulae to do validations and stuff but not at all pro!

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

Check out text to columns!

like

Yup, text to columns is the way to go. You could select the data in a column, data tab, text to columns. Or ALT+A+E after you have your data selected

like

Easy.
A1 is value.
B1 is new column1
C1 is new column2

B1: =Left(A1,(Find(“ “,A1)-1)
C1: =Mid(A1,(Find(“ “,A1)+1),50)

smarthelpful

This will parse your text to new columns.

smart

From cell to column you can try “text to column”, if the cells are formatted in a predictable way. Not sure what you mean for cell to row

like

Data is Separated by space within single cell! I need to split data from single cell into multiple cell.

You can use ext.text plus search to locate the first (and subsequent) space, and extract the text you want to.

Text to columns will only work in a single column, which I'm not sure it's what you have. Ofc you can concatenate all cells into one column before using it.

Obs.: Yeah yeah I know you can use text to columns in multiple columns using dynamic merge, but pls, let's not go down with it, OP doesn't need anything crazy (at least not for now)

helpful

If you need to separate after every "fruit", just extract text till "fruits", and keep going for the next ones.

If you need to separate for spaces, use search/find to reach for every space.

If your text have no rule whatsoever, I'm afraid you'll need to do it manually

Nope text to column won’t work neither transpose. E.g single cell contains text like
Mango
Apple
Blueberry
Now I want to put them in separate cell. Does that help?

Thank you so much! This did simplify my work! All I have to do now is use transpose to get in vertical format and do some manual corrections! Thank you peeps!!!

If what other people are suggesting isn’t working, I have had success with this kind of problem using a non excel, low tech work around.. try pasting the excel cells into a word doc as text, then paste back into excel

Isn’t that manual work? I have like 100+ line items and saving excel to txt and then converting it to excel again helps a bit but it messes up dependent data that are in different cell in same row. But now attest I got few options so am working all in combing those! Thanks for the reply!

^ paste as text, then find and replace to remove quotes

Related Posts

Told my partner that I am experiencing severe covid symptoms and that am running around trying to get a test (very difficult where I am located right now). His response was to call him later today when I am *finally* at my desk to discuss a matter which requires work over the weekend. Is this normal?

like

Opinions on Global Mobility Services or Global Employer Services practice lines? What are these practices like?

likesmart

Which is better CGI, Cognizant or Robert Bosch. For Python Developer?

I got offer from Nagarro 15lpa as a react developer 3yoe. Role - senior engineer

Will they match 18lpa offer that I got ?

like

What do you consider the most difficult part about your job/role?

Does tiger analytics ask for counter offer letter while revising offer?

like

Thinking about getting liposuction. I’m 30F and I have had fat on my abdomen my whole life. I trained for a completed 2 70.3 Ironmans last year and I still had it. I’m worried about being judged but I’m also worried about the recovery disrupting my life. 4-6 weeks without exercise 😵‍💫

like

Guys Can we just all pump more into bitcoin and then dump collectively we are like freaking thousands here! Just helping those BTC guys still holding to make their $$ back

like

How bad is it if my company is not offering COL raises this year? They usually do 1-5% raises in May, but my manager tells me there will be none this year.

like

any recommendations on group workouts other than crossfit? back and knees can't handle cf these days.

like

Cool cool this is all normal.

Post Photo
like

I am interviewing to be an instructional coach. Any tips?

like

Best MBB for life sciences?

like

Hi , I am awaiting an offer from Citi , the position is located in their Tampa office. I would like to know the culture, WLB, Compensation, or any insights you are willing to provide. It is in compliance and control category. AVP, but also listed as an intermediate level.

Anybody have any insight on working in production in Philadelphia? Any creative shops, production companies or brands putting out great work?

like

Just joined a new agency. I contribute good ideas. I write relatively well. But sometimes I feel that I just get swallowed up by creatives who speak louder, present better. Any advice?

like

Yesterday I joined the JPMC mumbai and yesterday also I got the same offer from UBS Pune.
I want to work in pune location, please suggest.
Should I leave JPMC and join UBS pune?
Is it a right decision?

like
helpful

I want to diversify and thinking about buying an apartment for passive income purpose. This will be my first time and want to start small (maybe with a 1bhk apartment). I have only lived in New York and Chicago. Any suggestions moving forward? I am just starting and would love to get some advice. Is real estate a good option? How much should I invest? Things to consider before buying a real estate.

like

Additional Posts in Excel Genius

Is there a way to wrap your header text within access database?

like

Having an Index Match problem!

I would like to multiply the values in column C, "Company X Volume" by their corresponding Price in Column F. To do this, I know I have to index match, but I'm not sure how to do that correctly given these are not exact matches.

Any ideas?

Post Photo
like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

like

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

like

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

like

So i have a list of companies in a list (column A), and a “Y” next to them (column B) if i want to include them in my dataset.
Is there any way i can make a variable list, ie below the full dataset, of just the companies with “Y”, and it being dynamic?
Can post a screenshot tomorrow if useful to explain

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Is there a text to rows (instead of text to columns) trick?

like

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

like

I have an idea- unsure about the execution...

I have an Excel worksheet which has a table of items, i.e., a stock count of items available.

Is there a way to link this table to Microsoft forms/sharepoint whereby someone can request an 'x' amount of stock from this summary table and whatever the requestor asks for, once approved, is automatically deducted from the table of figures and the corresponding items

I appreciate that there is a lot of automation in the above. Would welcome any advice

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
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