Related Posts
Cool cool this is all normal.
Best MBB for life sciences?
Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Cool cool this is all normal.
Best MBB for life sciences?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Scan your QR code to download
Fishbowl app on your mobile
Check out text to columns!
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
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)
This will parse your text to new columns.
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
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)
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