PDA

View Full Version : Adding a blank string in between


lienlee
07-28-2010, 07:25 AM
IA003b
IA003d
IA008
IA009a
IA009e
IA010
IA012
IA019a
IA019bi want to add a blank space between the IA and the number.
for example the first one would be "IA 003b"
Bob Phillips
07-28-2010, 07:31 AM
Try

=LEFT(A1,2)&" "&MID(A1,3,99)