- 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
re: Excel Help: Return the first few letters of a cell...
Posted on 1/21/20 at 3:45 pm to finchmeister08
Posted on 1/21/20 at 3:45 pm to finchmeister08
=Left(cell,# of characters)
0
Posted on 1/21/20 at 3:48 pm to finchmeister08
There are a number of ways to do this. I use =trim(left(A1,find(" -",A1,1)))
A couple of others mentioned work too. Trim just helps in case you end up doing a lookup from another database that might not be formatted the same.
A couple of others mentioned work too. Trim just helps in case you end up doing a lookup from another database that might not be formatted the same.
Posted on 1/21/20 at 4:05 pm to SB9513
I thought this would be the "Concatonate" command.....
Posted on 1/21/20 at 4:19 pm to Tigers13
quote:
=LEFT(A1,SEARCH(" -",A1,1))
this worked as well, however i had to add an "iferror" to it just incase the " -" didn't exist. that would be due to a human error typo.
Posted on 1/21/20 at 6:27 pm to finchmeister08
Step 1: use the FIND operator to obtain the location the hyphen
Step 2: Use the LEFT operator to return the number of characters from step 1
Step 2: Use the LEFT operator to return the number of characters from step 1
This post was edited on 1/21/20 at 6:27 pm
Page 2 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News