Jim Metcalf
asked on
CONCATENATE QUESTION
I have a column that has number values in it, and I use a custom format of '00000000000'
this forces all of the values in the column to be displayed as ten digits.
example.
value of 77777 will be displayed as 0000077777
in the cell beside it I need a concatenate formula that will display
select * where acctno = 0000077777
my concatenate formula is
=concatenate("select * where acctno = ",A2)
unfortunately, my result is
select * where acctno = 77777
how do I get the result
select * where acctno = 0000077777
this forces all of the values in the column to be displayed as ten digits.
example.
value of 77777 will be displayed as 0000077777
in the cell beside it I need a concatenate formula that will display
select * where acctno = 0000077777
my concatenate formula is
=concatenate("select * where acctno = ",A2)
unfortunately, my result is
select * where acctno = 77777
how do I get the result
select * where acctno = 0000077777
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.