leecavturbo
Well-known Member
- Joined
- Jan 4, 2008
- Messages
- 681
I have a cell with prefix "item "@
when I enter a value eg 102 the cell displays item 102.
how can I copy that full string without macro and paste to other cell?
or a format that will insert the whole string as a value? probably complicated as would have to enter number then the cell refresh add the prefix and then re insert the full string as a value ?
when I enter a value eg 102 the cell displays item 102.
how can I copy that full string without macro and paste to other cell?
or a format that will insert the whole string as a value? probably complicated as would have to enter number then the cell refresh add the prefix and then re insert the full string as a value ?
Last edited: