Adding to last two digit in a cell with alpha numeric value

**jazbath** · 01-14-2020, 05:57 PM

Hi,
I have the following value in a cell:

aaa111bb-nn01-20

I am wondering if we can add 1 to last two digit to make it 21, with a formula.

Thanks for your help.

**gue2013** · 01-14-2020, 06:07 PM

if the value is in A1 then you can use

Please Login or Register  to view this content.

**jazbath** · 01-14-2020, 06:14 PM

Hey Gue2013,
Thanks for responding. Tried and it does't work.
It did not do anything.
Jaz

**gue2013** · 01-14-2020, 06:34 PM

sorry - german layout! please change ";" to ","

**jazbath** · 01-14-2020, 06:56 PM

thank you Gue, it worked fine.
Jaz

Adding to last two digit in a cell with alpha numeric value

LinkBack

Thread Tools

Rate This Thread

Display

Adding to last two digit in a cell with alpha numeric value

Re: Adding to last two digit in a cell with alpha numeric value

Re: Adding to last two digit in a cell with alpha numeric value

Re: Adding to last two digit in a cell with alpha numeric value

Re: Adding to last two digit in a cell with alpha numeric value

Thread Information

Users Browsing this Thread

Similar Threads

How to generate 16 digit unique random alpha numeric numbers?

[SOLVED] Alpha numeric with max 3 digit numbers based on criteria

[SOLVED] Return 2 digit numeral from either side of - in an alpha numeric string

Finding 6, 7 or 8 digit number ‘clusters’ anywhere in an alpha numeric text string

[SOLVED] Return latest Alpha / Numeric / Numeric Alpha Revision

[SOLVED] Adding Sum Formula Using Cells Containing Alpha and Numeric

sorting alpha numeric list by first left digit

Bookmarks

Bookmarks

Posting Permissions