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
How to add @ in laptop - Guide
How to add subtitles in kmplayer - Guide
How to add photo in word resume - Guide
Excel add days to date - Guide

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!