• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel 2003: How to question

minendo

minendo

Elite Member
Currently, I have a spreadsheet that has 2000+ part numbers that I need to automatically insert a * before the 1st character and after the last character. Strings are not all the same length so what is the easiest way to do this?
 
After trying numerous methods I found an equation that works. Incase anyone ever needs to do something similar here it is:

=LEFT(A2,0)&"*"&A2&RIGHT(A2,0)&"*")
 
Last edited:
Even easier is to put the following, assuming your data is in column A:

In column B: ="*"&A1&"*"

Fill down to the bottom. Now you have two choices:

1) Hide column A

2) Copy column B and Paste Special -> Values into a new column. Delete both column A and B and insert a new column with the values you copied from column B. (it will require an new cut and paste)

**Edit, I was assuming your data was in columns, which may not be your case.
 
Last edited:
You must log in or register to reply here.

TRENDING THREADS

Back
Top