I need to auto derive data for column A using "-" as an identifier for
input from Column B. See below:

Column A Column B
S14134 S14134
S14134 S14134-1
S14134 S14134-2
S14134 S14134-3

Any help is appreciated.

Tims


--
tims
------------------------------------------------------------------------
tims's Profile: http://www.excelforum.com/member.php...o&userid=37197
View this thread: http://www.excelforum.com/showthread...hreadid=569088