Previous Topic Next Topic

How to add the number with alphanumeric

Closed
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

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
theHawk -
Counselor -

13 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Removing " false" value in "IF"
JIN -
share -

10 responses