PDA

View Full Version : Add " at the beginning and end of a string



austenr
06-11-2007, 01:47 PM
How can I put quotes around a string in a cell?

ex. 123 should be "123"

Thanks

Not using F2

CCkfm2000
06-11-2007, 02:29 PM
use the prime ' key, you will find this just above the right shift key.

e.g enter '
enter "
enter 123
enter "

will show "123"


hope this helps

Bob Phillips
06-11-2007, 03:04 PM
With Activecell
.Value = """" & .value & """"
End With

mikerickson
06-11-2007, 06:12 PM
=CHAR(34)&"123"&CHAR(34)

austenr
06-11-2007, 06:33 PM
Thanks sid, Mike.. Solved

Bob Phillips
06-12-2007, 02:43 AM
Sid?

johnske
06-12-2007, 03:15 AM
Yeh - El Xid :rotlaugh: :rofl:

Bob Phillips
06-12-2007, 04:08 AM
Sid sold off British Gas.