Autofilling text special character if new cell/row is empty

jmccall93

New Member
Joined
Mar 14, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have an invoice spreadsheet and instead of being blank I would like the spreadsheet to enter # in each new first cell of a newly added I'm thinking a IS BLANK row, but leave my invoice number fine if I end up populating an invoice number behind the #. I'm thinking an ISBLANK formula but I cant figure out how to specify that the False portion needs to be changeable for random invoice numbers filled in.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Can you give an example of a picture or table to make it easier for someone to answer your question?
 
Upvote 0
Here is a sample of my spreadsheet. Once you open it, in the first column every invoice is preceded with a # sign. Id like the pound sign to automatically appear and them allow me to add individual invoice numbers behind it.
 

Attachments

  • Screenshot 2024-03-27 081258.png
    Screenshot 2024-03-27 081258.png
    136.1 KB · Views: 8
Upvote 0

Forum statistics

Threads
1,215,097
Messages
6,123,076
Members
449,094
Latest member
mystic19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top