Add Brackets In Excell
Hello,
I have excell spreadsheets where I need to add brackets [ ], quotations ” ” and { } around each word in a column.
For example I send you this:
AAAA
BBBB
CCCC
DDDD
needs to come back to me
AAAA [AAAA] “AAAA” {AAAA}
BBBB [BBBB] “BBBB” {BBBB}
CCCC [CCCC] “CCCC” {CCCC}
DDDD [DDDD] “DDDD” {CCCC}
I know there is some type of simple formula to use in excell I just dont know how to do it.
I have about 5 spreadsheets this needs to be done with. Most of the spreadsheets only have one column. One spreadsheet has 26 columns.
If someone knows hows how to do this it shouldnt take long.
I need this done asap and will hire the first person who sends me an example showing me they know how to do it.
Make up your own excell spreadshhet with a column of 20 words and then show me you took the original column and added the [ ] ” ” and { } and now have 4 columns
Please make sure you know how to do this with a formula in excell. There are thousand and thousands of words and to do it by hand will be impossible.
Thanks,
Dealflo


