I have an excel sheet filled with clients names, emails and date of when they joined our newsletter.
In column B, I have their names listed normally. I have over 200 rows. What I wanna know is how can I add double quotes to the name?
For example B6=Jimmy Buchanan should become "Jimmy Buchanan"
I just wanna be able to add quotes to the names and emails automatically.
You can either
a) use formulae in adjacent cells and copy paste results as values only over originals, eg
C6: =CHAR(34)&B6&CHAR(34)
or
C6: =""""&B6&""""
copied down ... then copy / paste special / values only the results in C results over B originals.
b) use VBA, eg:
above assumes range of values in B commences in B1 and all values in B are to be altered.
Please Login or Register to view this content.
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks