Concatenate

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear All,
there is anyway with concatenate, when i am choosing a
text to format specific characters of this format?
eg
A1 -- Actual
A2 -- 2003

B3 -- to ask "Act 2003"

Thanks in advance,
Manos
 
Manos,

Truncating can only be done with string functions, for example

=LEFT(A1,3) & " " & A2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Manos!

The best I can come up with is:

=LEFT(A1,3)&" "&A2

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top