hi MasseyHarry12, welcome to the forum. so are you adding the brackets through Format Cells? if so & assuming your data starts from A2:A5000
1. select A2.*
2. click & drag the scroll bar to the end where the data of column A ends (row 5000)
3. press & hold the SHIFT key & left click on the last cell in column A (A5000). you should see them all selected
4. press CTRL + G -> Special -> Constants -> OK. now only non-blanks are selected
5. do not click anywhere else. press CTRL + 1 to format cells
6. Custom Format -> <@>
7. hit CTRL & ENTER
the above would work if column A are not formulas. if they are, try using formulas in B2:
=IF(A2="","","<"&A2&">")
copy it down to B5000. copy B2:B5000 & paste values in Column A. is that what you need? otherwise, uploading a sample Excel file in the thread will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon
ideally, it should contain your desired results
Bookmarks