how to add a charater in front of part number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of part number and the part number starts with 310xxxx.
How can I add " to make it "310xxxx?
 
use another column with a formula of

="3100"&A1

copy it down, the copy and Paste values and remove the old column A.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Sorry, then just use ="'"&A1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
MS word Find and Replace using Regex - Help required 0
Identify part number in list and tag it with characters from another list 4
Form for Parts-Tools Lists 0
Help With Searching For Strings In Part Numbers 3
Formula For Sorting Part Numbers 1
How Do I Find Different Values In A String? 2
Lower-Case Characters 2

Back
Top