If/Concatenate functions

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I am trying to write a formula that, if the cell begins
with specific numbers, say 848, it will concatenate with
another cell. Is there a calculation operator or some
type of function I just don't know that will help me do
this? My thought was an if function stating whatever
cells begin w/ "848" contatenate, if not use the original
number, but I can't figure it out.
 
Tom,

Using the numbers in A1 and what you want to concatenate with in B1,
try the following in C1:

=IF(LEFT(A1,3)="848",A1&B1,B1)

John
 
=IF(LEFT(A1,3)=848, A1&B1, A1)
will concatenate A1 and B1 into another cell (the cell with this formula) if
A1's value starts with 848, otherwise you get just A1's value.
Bernard
 
Back
Top