Hi all,
Before I begin this question, and before you tell me we dont do homework, I would like to state that I have read a few articles, I have tried a couple of functions (=REPLACE, =SUBSTITUTE) but i'm not able to get the reuslts require, I'm new to Excel
Question: Useappropriate text functions to shorten the variable names to something like Arizona Females Young, Arizona Females Old, and Arizona Females All, also is there a way to do it automatically for all variables in 1 function. The screenshot is attached.
It is kind of urgent (I understand people help within their own time).
Thanks in advance.
Recommended Answers
Jump to Postthis link will explain everything on how to use substitute and replace.
https://spreadsheeto.com/replace-and-substitute-text/
Jump to Posti hope this explains.
Jump to Postso thats when u can use the formula =RIGHT(A4, LEN(A4)-2) this will remove the fight 2 letters
All 9 Replies
Gilbertsilva123
30
Light Poster
ami_2
commented:
Hi, thanks for the reply I saw that post =substitute works but what if i want to remove some words from the right and i want to do this for the rest?
+0
Gilbertsilva123
30
Light Poster
ami_2
commented:
I'm sorry, I am trying hard to understand but maybe I'm not getting it, I'll manually edit and show you what i want
+0
Gilbertsilva123
30
Light Poster
ami_2
commented:
Please see the screenshot below
+0
ami_2
0
Newbie Poster
Gilbertsilva123
30
Light Poster
ami_2
commented:
Maybe can you show me an example of the function with the screenshot above?
+0
Gilbertsilva123
30
Light Poster
ami_2
commented:
the reason i am not opting for that option is because i have so many states
+0
Gilbertsilva123
30
Light Poster
ami_2
0
Newbie Poster
Gilbertsilva123
30
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.