How to blank out some numbers with ####

  • Thread starter Thread starter andysa
  • Start date Start date
A

andysa

Does anybody know how I can blank out the first four numbers in a box
with #### (eg 2323534534 would read ####534534).

Thanks
 
One way to do this
Assuming your number 2323534534 is in A1, enter the following in cell
B1
="####"&RIGHT(A1,6)
This will give B1= ####534534

Hope this helps

Mike
 
One way is ="####" & RIGHT(A1,LEN(A1)-4)
Assuming your original number is in cell A1
 
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

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Excel Concatenate with line breaks but ignore blank cells 3
Numbering rows and skipping blanks 3
excel 2007 numbers truncated 1
Insert Blank Row with data match change 1
Sorting a list of numbers 3
Data Validation to exclude blank cells 6
Sorting by rows with differing numbers of cell entries 3

Back
Top