LinkBack URL
About LinkBacks
Hi
i had both texts and numbers in a cell and i want to separate them to two different cells.
Thanks.
Hi
i had both texts and numbers in a cell and i want to separate them to two different cells.
Thanks.
Can you post a sample worksheet so people can see what you need?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Find the sample sheet..
in this in column A i had both text and number..i want to separate the text and column..
cant find the sample sheet!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Please find the sheet
well, this could work, a little long but seems to work...
=LOOKUP(9E+99+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1)))))
For text this ARRAY formula
Formula:
Please Login or Register to view this content.
For numbers this regular one.
Formula:Please Login or Register to view this content.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks