Mixed Text & Numbers -- Increment the Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A1 has the string, "WW01", and I want cell A2 to display the string, "WW02", cell A3 to display "WW03", etc....

If I change cell A1 to "WW12", I want the other cells to incement their numbers also (WW13, WW14, etc....)

TIA,
Rick
===============================
There is never a wrong time to do the right thing.
 
Hi
some ways:
1. using formating
- in A1 put the number '1'
- in A2 the formula:
=A1+1
- copy this formula down
- now format the cell with the custom format
"WW"00

2. using TEXT
put the following formula in A1
=TEXT(ROW(),"""WW""00")
and copy this down
 
Copy this formula down from A2 as long as needed

=IF(A1="","","WW"&TEXT(MID(A1,3,255)+1,"00"))

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


Rick said:
A1 has the string, "WW01", and I want cell A2 to display the string,
Click to expand...
"WW02", cell A3 to display "WW03", etc....
If I change cell A1 to "WW12", I want the other cells to incement their
Click to expand...
numbers also (WW13, WW14, etc....)
 
Thank you, this is a simple, elegant solution. I also appreciate the sppedy response.

Rick

-----
 
Back
Top