- 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: Return the first few letters of a cell...
Posted on 1/21/20 at 3:18 pm
Posted on 1/21/20 at 3:18 pm
Basically, A1 contains:
Name - Description
How do I return just the "Name" in a new cell instead of the full "Name - Description"?
Name - Description
How do I return just the "Name" in a new cell instead of the full "Name - Description"?
19
Posted on 1/21/20 at 3:19 pm to finchmeister08
Text to Columns
Posted on 1/21/20 at 3:19 pm to finchmeister08
Learn to code...
No seriously, that’s going to be in VBA territory
No seriously, that’s going to be in VBA territory
Posted on 1/21/20 at 3:19 pm to finchmeister08
Are the names all the same number of characters?
Posted on 1/21/20 at 3:20 pm to LNCHBOX
quote:
Are the names all the same number of characters?
nope
Posted on 1/21/20 at 3:21 pm to finchmeister08
Column A is all you have in the sheet? Nothing in B, C, etc? Then yes, Text to Columns. Set your delimiter to be the dash. Assuming by "return" you mean, to separate the data? Or do you mean you're trying to get it to be underneath but in the same cell?
If the former - Data > Text to Columns > select "other" as your delimiter and type a dash. Done. It will put everything after the dash into column B.
If the former - Data > Text to Columns > select "other" as your delimiter and type a dash. Done. It will put everything after the dash into column B.
This post was edited on 1/21/20 at 3:23 pm
Posted on 1/21/20 at 3:21 pm to LNCHBOX
yea if they are you could just use left.
If they are between 4-7 you could do that then chop as necessary. not clean but better than doing it all
If they are between 4-7 you could do that then chop as necessary. not clean but better than doing it all
Posted on 1/21/20 at 3:21 pm to finchmeister08
Are you wanting to auto fill as you type in a value? You can do that with a macro, it’s online if you search via autofill
Posted on 1/21/20 at 3:21 pm to finchmeister08
Tech Board
Posted on 1/21/20 at 3:22 pm to finchmeister08
=left(a1,5)
Posted on 1/21/20 at 3:22 pm to finchmeister08
Select the cell with the info you want.
In the data tab, select text to columns.
Select Delimited. Click next
Then enter your dividing character, in your case I'm guessing it is the hyphen, in the other box.
then select your destination cell
Edit : Dang y'all are fast.
In the data tab, select text to columns.
Select Delimited. Click next
Then enter your dividing character, in your case I'm guessing it is the hyphen, in the other box.
then select your destination cell
Edit : Dang y'all are fast.
This post was edited on 1/21/20 at 3:27 pm
Posted on 1/21/20 at 3:23 pm to finchmeister08
If they all have a space before the hyphen, you can literally type the "Name" in a new column for the first couple of rows and Excel will asked to autopopulate the rest of that column with just name. Hit "Enter" when the row looks populated but greyed out.
Little known feature I use a whole lot.
There are also formulas you can use, but this is WAY easier.
Little known feature I use a whole lot.
There are also formulas you can use, but this is WAY easier.
Posted on 1/21/20 at 3:23 pm to finchmeister08
something something pivot tables
Posted on 1/21/20 at 3:26 pm to thedrumdoctor
quote:
Select the cell with the info you want.
In the data tab, select text to columns.
Select Delimited. Click next
Then enter your dividing character, in your case I'm guessing it is the hyphen, in the other box.
then select your destination cell
this worked flawlessly. thanks.
Posted on 1/21/20 at 3:26 pm to finchmeister08
=LEFT(A1,SEARCH(" -",A1,1))
Posted on 1/21/20 at 3:26 pm to finchmeister08
Alt+F4
Posted on 1/21/20 at 3:28 pm to finchmeister08
Column A is the Descriptions mother.
Posted on 1/21/20 at 3:33 pm to finchmeister08
=LEFT(A1,(FIND(" ",A1,1)-1))
Posted on 1/21/20 at 3:36 pm to finchmeister08
=LEFT(A1,*number of letters in the name*)
Boom
Boom
Page 1 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News