Assume data in A2 down
To return it as text,
in B2, copied down:
="30"&LEFT(A2,2)
To return it as a real number,
in B2, copied down:
=("30"&LEFT(A2,2))+0
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"TED" wrote:
How do I concatenate a fixed number (like "30") and the first two #'s of
another cell that also contains text?
For example, joining 300 and another cell that has 2509Peters to form 3025