Dear ,
Hope every body going well.
Kindly suggest me a formula to split the data based on the space, from column A to column B, C, D etc.
Locations Location 1 Location 2 Location 3 Location 4 Location 5 Location 6
HB1E HB1F HB1G HB1H
HB1A HB1B HB1C HB1D
GNF9A GNF9B
GNF8A
GNF7
GNF6
GNF5C
GNF5A GNF5B
GNF4C GNF4D
GNF4A GNF4B
GF8E GF8F GF8GF
GF8A GF8B GF8C GF8D GF8E GF8F
Thanks and Regards
Shihab
The text to columns feature on the data ribbon is designed to do this for you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Here is a link to what AliGW is suggesting:
https://support.office.com/en-us/art...A-7A3E9C363ED7
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Assuming you have data in A1
Then Try
B1Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you very much Mr. Ankur Shukla, It is the formula what I search.
Happy to help you but the easiest solution is text to column as posted #2 & 3 mentioned.
I know the text to column but due its usage character formula will be convenient for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks