I need to add prefix and suffix to my list. How do I do that?
For example,
Channel should become [Channel].
ABCD should become [ABCD]
Can anyone suggest a simple way to do the same? Much appreciated. Thanks.
-- Adi
I need to add prefix and suffix to my list. How do I do that?
For example,
Channel should become [Channel].
ABCD should become [ABCD]
Can anyone suggest a simple way to do the same? Much appreciated. Thanks.
-- Adi
You could probably create a custom format, or you could use a formula
="[" & A1 & "]"
As Stephen pointed out a Custom Format may well suffice: "["@"]"
(this leaves the underlying value as entered, ie ABCD remains though it appears and prints as [ABCD])
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks