- 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
Excel Help Please - ASAP
Posted on 12/14/15 at 3:47 pm
Posted on 12/14/15 at 3:47 pm
I need assistance with deleting content from a cell... but not the whole cell.
For instance, one cell has "First Name, Last Name, Date, Time, Quarter"
And I want to delete everything but the "First Name, Last Name"
Is that possible? Can I "search" for data in the spreadsheet? for instance in terms of a boolean search, "delete all '*/*/*' and maybe 'Q*'"...
I know, I know, "Tech Board!"... but I have a deadline for COB today and need to exposure that only the OT can provide...
For instance, one cell has "First Name, Last Name, Date, Time, Quarter"
And I want to delete everything but the "First Name, Last Name"
Is that possible? Can I "search" for data in the spreadsheet? for instance in terms of a boolean search, "delete all '*/*/*' and maybe 'Q*'"...
I know, I know, "Tech Board!"... but I have a deadline for COB today and need to exposure that only the OT can provide...
Posted on 12/14/15 at 3:49 pm to yankeeundercover
double click in the cell, delete what you need
Posted on 12/14/15 at 3:49 pm to yankeeundercover
Go to File
View
You're fricked
View
You're fricked
Posted on 12/14/15 at 3:50 pm to yankeeundercover
You could try to use data->text to columns.
Move everything but first name, last name to a new cell and then delete it.
Move everything but first name, last name to a new cell and then delete it.
Posted on 12/14/15 at 3:50 pm to yankeeundercover
right click ...clear contents
Posted on 12/14/15 at 3:50 pm to Titan
concatenation, look it up, should solve the issue
Posted on 12/14/15 at 3:51 pm to yankeeundercover
Are all the cells cataloged the same way?
like date, time, and quarters have the same amount of numerals?
You can tell excel to remove so many character from the right of the cell.
If all your cells are formatted the same, then you can use this, no matter how long people's names are.
Or you can export your data to a txt file and insert dividers like tabs and semicolons manually, then import it into excel.
like date, time, and quarters have the same amount of numerals?
You can tell excel to remove so many character from the right of the cell.
If all your cells are formatted the same, then you can use this, no matter how long people's names are.
Or you can export your data to a txt file and insert dividers like tabs and semicolons manually, then import it into excel.
Posted on 12/14/15 at 3:51 pm to yankeeundercover
First search system 32 and delete that. Next, don't jerk around all day and maybe you could get your work done on time.
Posted on 12/14/15 at 3:52 pm to yankeeundercover
Posted on 12/14/15 at 3:52 pm to yankeeundercover
You could use text to columns and delimited option and pick comma as the separator and split that single column into multiple columns and delete the ones you don't need. Then merge the remaining columns. That will probably work.
ETA: I said the exact same thing as the guy above me...
ETA: I said the exact same thing as the guy above me...
This post was edited on 12/14/15 at 3:54 pm
Posted on 12/14/15 at 3:53 pm to anc
quote:
Serious answer.
Use Text to columns to get all the data in separate cells.
Delete the cells you don't need
You would have First Name, Last Name in two different columns, then you could combine those columns if you needed one.
this
Posted on 12/14/15 at 3:53 pm to ThePenIsMightier
quote:
Move everything but first name, last name to a new cell and then delete it.
We have a winner, easiest way to solve your problem
Posted on 12/14/15 at 3:54 pm to ThePenIsMightier
quote:
You could try to use data->text to columns.
Move everything but first name, last name to a new cell and then delete it.
With different lengths of names though that would have all different results though wouldn't it?
Posted on 12/14/15 at 3:56 pm to Mizzoufan26
quote:
With different lengths of names though that would have all different results though wouldn't it?
That's why my response is the best!
Posted on 12/14/15 at 3:56 pm to Mizzoufan26
quote:
With different lengths of names though that would have all different results though wouldn't it?
Yes, thats why you have to use Text to Columns
Watch for stragglers like First Name Last Name Jr. or III, but this should do the trick.
Posted on 12/14/15 at 3:56 pm to ThePenIsMightier
quote:
You could try to use data->text to columns.
This....Once everything is in seperate columns, you can concatenate the two name columns into one.
Posted on 12/14/15 at 3:56 pm to yankeeundercover
wait a sec, this is a trick questions right?
Shouldn't you have a hot little co-ed assistant to do this for you
Shouldn't you have a hot little co-ed assistant to do this for you
Posted on 12/14/15 at 4:07 pm to DirtyMikeandtheBoys
I'm trying to do this and it's only capturing the first name... leaving the rest of the empty fields blank
Posted on 12/14/15 at 4:08 pm to TheAlmightySmash
quote:
First search system 32 and delete that.
It's amazing how many people forget to do this.
Posted on 12/14/15 at 4:08 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
Do what I said.
If your cells are all arranged the same way you can use a character code to remove all the uneeded characters to the right of the name.
Popular
Back to top
Follow TigerDroppings for LSU Football News