Removing prefix in number range

[[email protected]]

Good day all,

Please in the attached, I have a column named ST Number. All the numbers began with IC- before other values. What formular can I use to remove the prefixes (ie: IC-)? Please any contribution will be highly appreciated.


Thanks.

[NBVC]

If you want to make the change in-situ, then select the column and press CTRL+H and then replace IC- with nothing in the Replace With box... click Replace all.

If you want a formula, then

=Substitute(B2,"IC-","")+0 copied down.

[Ron Coderre]

Try this:

• Select the column of ST NO.'s
• Data.Text-to-columns
...Check: Delimited...Click: Next
...Check: Other..Type a dash (-) in the empty box...Click: Next
...Click the first column...Click: Skip this column
...Click: Finish

That will remove the prefixes.

Is that something you can work with?