Removing characters
If you want to place the truncated numbers back to column A then select
column B, Copy/PasteSpecial-values to column A. Then you can delete the
helper column!
Stefi
€žMaksko€ť ezt Ă*rta:
Hi Stefi,
Thank you for Your advice, but i tried now and its not working, can You give
me same explanation about the formula.
Onceagain thank You for your support.
Best Regards, maksko
"Stefi" wrote:
=IF(LEFT(A2,3)="555",MID(A2,4,254),A2)
Regards,
Stefi
€žMaksko€ť ezt Ă*rta:
Hi to all,
Of the beginning I would like to thank you for the advice about my previous
question, it was useful.
I have needed advice for a second time or maybe a formula for removing some
characters from the cell or columns,
For example
If I have column with a tel. numbers and I would like to remove first three
numbers (characters) if they are ``555`` on the beginning of the field.
Example:
Tel. number
5553265598
555984236
5478896
45623178956
78246645
555123556
The results that I would like to have a
Tel. number
3265598
984236
5478896
45623178956
78246645
123556
The same column, but only without €ś555€ť
I hope that you are going to help me, giving me advice how can I do this or
maybe the problem can be solved by formula.
Thank you.
|