Hello guys,
Do you know how to add a hashtag before a word or number in calc? For example: Let’s use the word Apple and I want to add a hashtag before it. Just like this “#Apple” but with a formula. Is there a formula that can do this in order to have a whole list of words listed with a hashtag?
Do you want a formula? Find and Replace works for this
Select the cells you want prefixed
- Open Edit > Find and Replace (Ctrl+H)
- In the Find field enter
^. - In the Replace field enter
#& - Tick Current selection only
- Tick Regular Expressions
- Click OK
If you do want a formula then you will need another column. Assuming the strings start in cell A2 then in cell B2 enter ="#"&A2 and then copy down. Then select the cells in column B, copy and paste as unformatted text to remove the formula
1 Like
Thank you. I did it just like you mentioned.
Or use Menu / Data / Calculate / Formula To Value.
BTW: Has no analogue in Excel.
1 Like