LinkBack URL
About LinkBacks
Hello,
I am looking to find specific data in a string, copy that data + 10 following Chars to a new cell.
In the attached example, find "Number:" and the following 10 Chars.
Thank you,
Hello,
I am looking to find specific data in a string, copy that data + 10 following Chars to a new cell.
In the attached example, find "Number:" and the following 10 Chars.
Thank you,
Last edited by mr_mark; 11-27-2024 at 12:04 AM. Reason: SOLVED
Try this in B2.
copied down.
=IFERROR(MID(A2,FIND("Number:",A2),17),"")
Perfect. Thank you very much for your prompt and concise reply.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks