Moving part of a text from one column to another

[dunn01]

Would like to move part of the text that say "ABCxxxxxxxx" from one column to
another.

In the other column would like the value to be "ABC".

Any thought?

 

[Jan De Messemaeker]

Hi,

Through a formula? Through VBA?
The formula would be left([Text1],3)
Hope this helps

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf