Solved help with changing 9 47 6 to [9:47:6]

April 19, 2013 at 12:22:11
Specs: Windows 7
basically i need the following to happen... i will put in cell A1: 9 B1: 47 C1 6

and i want excel to change my data to look like [9:47:6] in cell D1


See More: help with changing 9 47 6 to [9:47:6]

Report •


#1
April 19, 2013 at 12:45:27
✔ Best Answer
Use the CONCATENATION function:

=CONCATENATE("[",A1,":",B1,":",C1,"]")

or the Concatenation operator - &

="["&A1&":"&B1&":"&C1&"]"

The main point is that the hard coded text needs to be enclosed in quotes.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question