Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

My problem is basically I have to erase the number 1 in front of 19,000 numbers, this will take way too long if i go one by one i was wondering if you can help me please?
Solved by X. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/09/2017 - 08:47
Thanks for choosing Got It Pro. I’m happy to be able to help you today.
Excelchat Expert 16/09/2017 - 08:47
I’d love to help you with your problem if you would kindly give me more information.
Excelchat Expert 16/09/2017 - 08:50
Hello
User 16/09/2017 - 08:50
hello
Excelchat Expert 16/09/2017 - 08:50
I’d love to help you with your problem if you would kindly give me more information.
User 16/09/2017 - 08:50
basically
User 16/09/2017 - 08:51
what else do you need?
User 16/09/2017 - 08:51
information wise
Excelchat Expert 16/09/2017 - 08:51
it's better if you can upload some data on sheet
User 16/09/2017 - 08:52
i tried sharing it \
User 16/09/2017 - 08:52
i did not who to send it to
User 16/09/2017 - 08:52
can you give me an email to send it to?
Excelchat Expert 16/09/2017 - 08:52
you can put some data on right side sheet
Excelchat Expert 16/09/2017 - 08:53
You can copy paste data on right side sheet
User 16/09/2017 - 08:53
it says these actions are unavailable
User 16/09/2017 - 08:54
ill give you an example
Excelchat Expert 16/09/2017 - 08:54
ok upload the file here
Excelchat Expert 16/09/2017 - 08:54
you can see a paper click icon right side of type box
Excelchat Expert 16/09/2017 - 08:54
click on it and upload
Excelchat Expert 16/09/2017 - 08:56
Hello
User 16/09/2017 - 08:56
i am cecking
Excelchat Expert 16/09/2017 - 08:56
ok
User 16/09/2017 - 08:56
checking**
User 16/09/2017 - 08:57
i can not find a paper lcip
User 16/09/2017 - 08:57
clip**
Excelchat Expert 16/09/2017 - 08:58
you can see where you typing
User 16/09/2017 - 08:58
what?
Excelchat Expert 16/09/2017 - 08:59
can you see any icon near chat box?
Excelchat Expert 16/09/2017 - 08:59
or you can upload on googlesheet and send it to me
User 16/09/2017 - 08:59
oh i found it
User 16/09/2017 - 08:59
but it is on excel but online
User 16/09/2017 - 08:59
so what do i do
Excelchat Expert 16/09/2017 - 09:00
share me the link
User 16/09/2017 - 09:01
it is not letting me
Excelchat Expert 16/09/2017 - 09:01
ok got it
Excelchat Expert 16/09/2017 - 09:01
explain me
Excelchat Expert 16/09/2017 - 09:01
then i will try to give you solution
Excelchat Expert 16/09/2017 - 09:06
hello

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc