- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
0
Posted on 12/14/15 at 4:09 pm to yankeeundercover
Definitely "text to columns" route.
Posted on 12/14/15 at 4:10 pm to yankeeundercover
I'm not understanding the issue. String functions are your friend.
Posted on 12/14/15 at 4:10 pm to yankeeundercover
quote:
I'm trying to do this and it's only capturing the first name... leaving the rest of the empty fields blank
Can you give us an idea of what the contents look like?
Is it First,Last,date,time,etc?
ETA: Never mind, you should be able to tell it to create a new column at every "," then find and replace all "spaces". Then use =A1&","&... until it looks like you want.
This post was edited on 12/14/15 at 4:12 pm
Posted on 12/14/15 at 4:12 pm to Pectus
I need all the data in the cell, but I need to be able to sort it... I'm able to ALMOST get it there... but it's not allowing all of the data to be captured...
It's almost like the cells are merged and their taller than a single line..?
It's almost like the cells are merged and their taller than a single line..?
Posted on 12/14/15 at 4:14 pm to yankeeundercover
quote:So, you have line breaks in the individual cells? You still need the first and last name?
I need all the data in the cell, but I need to be able to sort it... I'm able to ALMOST get it there... but it's not allowing all of the data to be captured...
It's almost like the cells are merged and their taller than a single line..?
Posted on 12/14/15 at 4:15 pm to TFS4E
Let us know if you have to re-do a lot of data entry. We all want to laugh.
Don't forget that delete the 32 thing. None of the techniques work until you do that and unlock the system.
Don't forget that delete the 32 thing. None of the techniques work until you do that and unlock the system.
Posted on 12/14/15 at 4:16 pm to yankeeundercover
quote:
It's almost like the cells are merged and their taller than a single line..?
Are you over the age of 65?
Posted on 12/14/15 at 4:17 pm to yankeeundercover
quote:
I need all the data in the cell, but I need to be able to sort it... I'm able to ALMOST get it there... but it's not allowing all of the data to be captured...
It's almost like the cells are merged and their taller than a single line..?
Oh. Then unmerge them and expand the column width to see all the info.
Posted on 12/14/15 at 4:20 pm to TFS4E
quote:
Can you give us an idea of what the contents look like?
So it's what looks to be merges vertically...
_______________________
Last, First......|___________|
Value.............|___________|
Date-.............|___________|
Date________|___________|
Posted on 12/14/15 at 4:21 pm to DirtyMikeandtheBoys
If he has a name with a space in it then text to columns will ruin him... Del Frisco would be split into two columns and throw off everything.
If he has 500 rows then no big deal to fix.... Of he has 1,000,000 then he needs another solution.
If he has 500 rows then no big deal to fix.... Of he has 1,000,000 then he needs another solution.
Posted on 12/14/15 at 4:21 pm to yankeeundercover
quote:
So it's what looks to be merges vertically...
_______________________
Last, First......|___________|
Value.............|___________|
Date-.............|___________|
Date________|___________|
Someone formatted it like that within a cell?!
Is |__________| where the names are? What does it attempt to do when you do text to columns? You can set it to select specific characters to separate by. Lynx is correct, need to be careful of names with spaces.
This post was edited on 12/14/15 at 4:24 pm
Posted on 12/14/15 at 4:22 pm to Pectus
quote:"The cell contains multiple data values. Merging will only keep the top left value"
Oh. Then unmerge them and expand the column width to see all the info.
Same thing happens when I click "unmerge"
Posted on 12/14/15 at 4:23 pm to TFS4E
quote:It was an export from a program...
Someone formatted it like that within a cell?!
Posted on 12/14/15 at 4:24 pm to yankeeundercover
Paste a screen shot with fake numbers and names.
Posted on 12/14/15 at 4:26 pm to yankeeundercover
quote:
It was an export from a program...
Damn, frick that program. Like Lynx said, can you post a screenshot to give an idea? I'm having trouble picturing it.
Posted on 12/14/15 at 4:26 pm to TFS4E
What happens when you click wrap text? Or unwrap it.
I can't tell if you are having issues with the format of the cell or if it is just a weird dump from a program
Either way, screen shot is necessary
I can't tell if you are having issues with the format of the cell or if it is just a weird dump from a program
Either way, screen shot is necessary
This post was edited on 12/14/15 at 4:29 pm
Posted on 12/14/15 at 4:28 pm to yankeeundercover
quote:
It was an export from a program...
What program?
Couldn't you choose a file type that excel accepts?
Posted on 12/14/15 at 4:32 pm to hiltacular
quote:
What happens when you click wrap text? Or unwrap it.
I can't tell if you are having issues with the format of the cell or if it is just a weird dump from a program
This.
Posted on 12/14/15 at 4:32 pm to yankeeundercover
Text to column, then use an & formula to piece the names back together if that's what you need.
Page 2 of 3
Popular
Back to top
Follow TigerDroppings for LSU Football News