Inserting brackets in a column in Excel
Hi Folks,
I have a lonnnnng column of data in Excel. TO properly utilize a command for a listserv I need to have square brackets around the data in the column. How can I get the brackets around data in each cell without having to do this one by one?
First three rows is what I want....
[apple]
[orange]
[grapes]
data
data
data
I have a lonnnnng column of data in Excel. TO properly utilize a command for a listserv I need to have square brackets around the data in the column. How can I get the brackets around data in each cell without having to do this one by one?
First three rows is what I want....
[apple]
[orange]
[grapes]
data
data
data
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER