How to add the number with alphanumeric

Closed

Excel

jay - Mar 10, 2010 at 04:41 AM
Biohazarus - Apr 6, 2010 at 10:13 AM

Hello,
Am facing issue while adding numbers to alphanumeric.Can any pl help me.

For example i have AB1, AB2, AB3 in one column and i want to add AB4 as in the next column by some kind of simple formula.Can any help me on this.

thanks
jay

How to add alphanumeric in excel
2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
Excel add days to date - Guide
How to add at the rate in laptop - Guide
How to clear formatting in excel - Guide
Excel mod apk for pc - Download - Spreadsheets

1 response

Answer 1 / 1

Biohazarus
Apr 6, 2010 at 10:13 AM

="AB" & (MID({Cell containing data},2,1)+1)

Similar discussions

Insert rows on change of value in Excel table

Counting number of times a value appears if..

If a cell contains any text then add a value

Find missing data in 2 columns (Excel)

Comparing columns and returning value

Removing " false" value in "IF"

Similar discussions

Subscribe To Our Newsletter!