- 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
Posted on 8/29/20 at 7:57 am
Posted on 8/29/20 at 7:57 am
In A1 I have a number let's say. LT30M9782345987
I want cell A2 to read 2345-987
I can get it to read 2345987 but without the dash by using =RIGHT(A1,7)
What would I need to insert into my formula to get the - to appear or 2345-987
I want cell A2 to read 2345-987
I can get it to read 2345987 but without the dash by using =RIGHT(A1,7)
What would I need to insert into my formula to get the - to appear or 2345-987
2
Posted on 8/29/20 at 8:13 am to CHEDBALLZ
=concatenate((left(right(a1,7),4));"-"; (right(a1,3)))
Not sure if I have the parenthesis lined up correctly.
Or you could do a second column where you parse the result.
Not sure if I have the parenthesis lined up correctly.
Or you could do a second column where you parse the result.
Posted on 8/29/20 at 11:08 am to Bestbank Tiger
I'll work with that, thanks a bunch
Posted on 8/29/20 at 1:02 pm to CHEDBALLZ
quote:
I'll work with that, thanks a bunch
Anytime
One caveat - Concatenate is definitely the command to join strings of characters. But I'm not sure if you use commas or semicolons between the strings. Excel uses one and Open Office uses the other and I can never remember which is which.
Posted on 8/30/20 at 10:05 am to Bestbank Tiger
Excel uses commas.
I would have broken that into 3 or 4 columns but that formula is more elegant
I would have broken that into 3 or 4 columns but that formula is more elegant
Posted on 8/31/20 at 8:35 am to CHEDBALLZ
Fwiw, if the length of the strings in column A isn't the same, you'll have to incorporate that into the equation
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News